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).
See solution in other versions of Access:
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.
In the combo box that displays "Group By". Select Max from the list.
Your query should now look like the following picture:
Advertisements