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 derfloh 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

    Works perfectly! Thanks, Virgil
  2. dbfNeophyte

    Increment a count based on test date order in a query

    Hi PH, Yes, having the correct wording for the search made all the difference. Here is what I have curretnly SELECT A.NAME, A.CLTESTTYPECD, A.CLTESTDATE, (SELECT Count(*) FROM tblNUMLitTesting WHERE NAME =A.NAME and CLTESTDATE<=A.CLTESTDATE)-1 AS RANK FROM tblNUMLitTesting AS A GROUP BY...
  3. 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...
  4. dbfNeophyte

    Droping specific records from Access query

    Hello Rick; Yes! This works very well. I am going to have to take some time with this to develop an understanding of the differences in what you are doing and what I did. Your approach makes much more sense. Thank you very much for your time and effort. Virgil
  5. dbfNeophyte

    Droping specific records from Access query

    Hi Rick: I have attempted including the SQL you sent, however my SQL skills are lacking and I could not get it to work. Also, I did not mention in my last reply, I am running Access 2000. Thanks for any help you can offer and for the link you sent. Virgil (dbfNeophyte)
  6. dbfNeophyte

    Droping specific records from Access query

    Hi Rick: I appoligize for the lack of information and will try your approach today as time permits. Here is the SQL for my query: SELECT DISTINCT qryYYHSDipGEDAttain.KEY_CLT, qryYYHSDipGEDAttain.CLDO, qryYYHSDipGEDAttain.CLCOUNSID, qryYYHSDipGEDAttain.CLLASTNAME, qryYYHSDipGEDAttain.CLFIRSTNAME...
  7. 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