list only most recent event in a query

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I am trying to create a record of training courses
employees have been on.
Each course attended is recorded in the coursebookings
table.
I want to display a record of only the most recent courses
attended
ie if they attended a course in 2001, a refresher in 2002
and 2003, I just want the query to list the refresher in
2003. The course names are the same eg first aid, but each
time the course runs it has a unique id (event ID) which
is a course running on a particular date.

I have tried using the Max function on the query on the
date of the course, but it still lists the earlier
courses. Do I combine the max date with something else.
I cant get my head round this!

thanks
 
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
 
Back
Top