Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: swimtiger
  • Content: Threads
  • Order by date
  1. swimtiger

    Finding Minimum or Maximum Value

    Hello, I tried searching so I would not ask a repeat question, but I did not find my answer. Without any further ado: I have a table that tracks clients check-in dates at centers. I would like my query to display a client's minimum check-in date and the center name. When I currently run my...
  2. swimtiger

    Beginner Question: How do I specify a month with a parameter query?

    I would like to create a parameter query that asks for the month instead of asking for a beginning and ending date. Currently, my criteria line looks like this: Between [Type the beginning date] And [Type the ending date] To view the records for July 02, I have to type 7/1/02 and 7/31/02. I...
  3. swimtiger

    Calculate difference between MAX and MIN dates

    I have a field that contains the date that a client was placed into a job. There are multiple placements for each client, and I would like to calculate the number of days between the first and last placements for each client.
  4. swimtiger

    Exporting sql db to access, how do i export relationships

    Let me start off by saying that this is the first time I have ever used MSQL server. My office has a SQL database that a company built for us, and it is stored on our SQL server. My boss wanted me to export this database into an Access database. I was able to transfer the data tables without...
  5. swimtiger

    count number of yes repsonses

    I have a table with 14 yes/no fields. I want to be able to count the number of yes responses that a user has.
  6. swimtiger

    wish to combine two fields into a new field

    Hello, I have done something like this before with SPPS and Excel. What I wish to do is combine the 'TYPE' field with the 'USERID' field into a new field called 'CODE.' So, if someone's 'TYPE' was 01 and their 'USERID' was 0997, their 'CODE' would be 010997. Doing this would help me...
  7. swimtiger

    Want to combine two fields into a 3rd unique field

    Hello, I have done something like this before with SPPS and Excel. What I wish to do is combine the 'TYPE' field with the 'USERID' field into a new field called 'CODE.' So, if someone's 'TYPE' was 01 and their 'USERID' was 0997, their 'CODE' would be 010997. Doing this would help me...
  8. swimtiger

    Want to combine two fields into a 3rd unique field

    Hello, I have done something like this before with SPPS and Excel. What I wish to do is combine the 'TYPE' field with the 'USERID' field into a new field called 'CODE.' So, if someone's 'TYPE' was 01 and their 'USERID' was 0997, their 'CODE' would be 010997. Doing this would help me...

Part and Inventory Search

Back
Top