Query to Extract records with latest date

[rkalapura]

Hai,

I have an employee annual performance review table "Review", with EmpNo, Reviewdate, ReviewedBy, Nextduedate etc. in Access 2010. This has around 600 records of past six years. I mean, average 4 to 5 records of each employee, depends how many years he work in company. How can I extract the last review records of each employ in a query? I tried to use max() function with Nextduedate, doesn't work, my procedure may be wrong. What should be the criteria I need to use to get only the last performance review of each employ from the table?


Really appreciate your help.

Thanks in advance.

[June7]

Could use DMax domain aggregate function.

SELECT * FROM tablename WHERE Nextduedate = DMax("ID", "tablename", "EmployeeID=" & [EmployeeID]);

[rkalapura]

Thanks June7. It works fine with Dmax(). I tried it before, but my procedure was wrong.

Thank you very much for assistance.