list only most recent event in a query

[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]

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

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

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article explains 4 ways to get the result.