Access: Query to retrieve max date in Access 2007

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

Question:  In Access 2007, 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 OrderDate field.

Select the Design tab in the toolbar at the top of the screen. Then click on the Totals button in the Show/Hide group.

A Total line should now appear in the Design view. By default, Group By will be selected. Instead, select Max from the list.

Your query should now look like the following picture: