Access Query - Only show the record with the most recent date

[rkf481]

I have ONE table in my DB called tblTraining. It contains training records imported from another file. I want to be able to build a query that will filter out duplicate records but pick the one with the most recent completion date.





Sample of table fields and data:

FirstName	LastName	Course	CourseDescrip	CompleteDate
Bob	Smith	123	Training A	12/1/2020
Marie	Parsons	48390	Training B	4/5/2012
Marie	Parsons	48390	Training B	7/2/2019
Bob	Smith	123	Training A	11/5/2021
Marie	Parsons	123	Training A	12/1/2022

I need a query that would return the following:

FirstName	LastName	Course	CourseDescrip	CompleteDate
Bob	Smith	123	Training A	11/5/2021
Marie	Parsons	123	Training A	12/1/2022
Marie	Parsons	48390	Training B	7/2/2019

Any help would be greatly appreciated.

[Micron]

You'd need a Totals query using Max of training date, I'd say. Something like

SELECT tblTraining.FirstName, tblTraining.LastName, tblTraining.Course, tblTraining.CourseDescrip, Max(tblTraining.CompleteDate) AS MaxOfCompleteDate
FROM tblTraining
GROUP BY tblTraining.FirstName, tblTraining.LastName, tblTraining.Course, tblTraining.CourseDescrip;