Query to retrieve max date in Access

Also learn how to create a query to retrieve max date in Access 2007 | Access 2003/XP/2000/97.

Question: In Access 2003/XP/2000/97, how can I build a query to select the latest date among several records?
Answer: To do this, open your query in Design view. Select the field that contains the date values. In this example, we've selected the Order_Date field.

Click on the summation button in the toolbar.


In the combo box that displays "Group By". Select Max from the list.


Your query should now look like the following picture: