totn Access

MS Access 2003: Query to retrieve max date

This MSAccess tutorial explains how to create a query to retrieve the max date in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft 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.

Microsoft Access

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

Microsoft Access

Your query should now look like the following picture:

Microsoft Access