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:

No comments:
Post a Comment