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!

  • Congratulations Rhinorhino 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: *

  1. dbfNeophyte

    Increment a count based on test date order in a query

    I need to Increment a count based on the test date (CLTESTDATE) for each Test Type Code (CLTESTTYPECD) with the oldest date being 1, the next oldest 2 and so on. The count for each person tested should never exceed 6 or 7, also the count needs to populate to a new field in the query. I will...
  2. dbfNeophyte

    Droping specific records from Access query

    I am running a query against my data and want to drop all records that are associated with an outcome of 413 (see example below) Client Title Outcomes Joe Smith 1B 413, 315, 412 Jane Jones 1B 315, 412 In the example above, I would not want Joe Smith to...

Part and Inventory Search

Back
Top