Show most recent

[CJ]

Hi Groupies

My database keeps track of training certifications. I need to keep a history
of recertification, so I may have the same person listed for the same course
but with a different date of training.

My report needs to show the person, the course and the date of training.
However, I only want the most recent date of training to show up. I can not
use unique records or unique value properties because I need the training
date to show up.

Any ideas?

 

[Allen Browne]

Use a subquery to identify the most recent record for the combination of
person + course.

This example shows how to get the top 1:
http://allenbrowne.com/subquery-01.html#TopN

If you don't need all the fields of that record returned, here's some other
approaches:
http://www.mvps.org/access/queries/qry0020.htm

 

[CJ]

Use a subquery to identify the most recent record for the combination of
person + course.

This example shows how to get the top 1:
http://allenbrowne.com/subquery-01.html#TopN

If you don't need all the fields of that record returned, here's some
other approaches:
http://www.mvps.org/access/queries/qry0020.htm

Thanks for steering me in the right direction Allen. I just needed to use
MAX.

.....sometimes you just need to borrow another brain.....