how to query for last test date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I find the most recent test date for each of a number of test results
for many people? Data is entered in this format: ID#, Date of test, score. A
person may have 1 or many dates of testing. I want to query for all ID#s with
the results for the most recent test date, even if it is only one date.
Thanks.
 
Use a totals query and change from Group By to Max for Date of test and Last
for score.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query multiple records 1
Sequential Record Use? 3
The query cannot be completed. 1
Conditional formating or similar for access query 4
Queries with date fields 1
Find last record in date field for each device in the device field 5
Update query to remove data 3
Query to select individual records 4

Back
Top