Select most current date of duplicate employee records

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

Guest

I need help wtih this one. I have a database that contains training
records. Each employee attends a certain class several times on different
dates. I need to creat a query that selects the last time that the employee
attended a certain class. Then I will need to do a calculation to that date
to show me how many years it has been since they attended. That last part I
can get just fine.

Buzz 1/5/2004 Adult CPR
Buzz 7/28/2003 Adult CPR
Buzz 12/3/2002 Adult CPR

Thanks for any assistance I can get.

Spotted Dog
 
Make a normal select query on the table, then while in design view go View >
Totals, and notice the new line headed Total: that appears in teh grid;
leave its setting to the default Group By under name and class, and change
to Max under date. This query will return the past data per name per class.

HTH,
Nikos
 
Back
Top