Search code examples
ms-access-2016

How to limit a query to only the most recent occurence in Access

I have three tables: Employees, Trainings, & TrainingSessions

I have a query that pulls LastName and FirstName from the Employees table, it pulls TrainingTitle and SessionDate from the TrainingSessions table, it also has an expression that calculates that date a renewal training is due.

Trainings can be completed multiple times but I only want information on the most recent occurrence of any individual training. How do I limit the list to only the most recent occurrence.

I'm just learning Access so please explain in the simplest terms possible. If you need more information, I'd be glad to provide.

Thanks!

Solution

  • I had to do MAX in a separate query on the renewal date column.