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.
 
Back
Top