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.
![](https://lh6.googleusercontent.com/-EDyZdQBAGIw/UAgfe29za6I/AAAAAAAAHTE/0fW6Vz0VoBY/s508/max_query001.png)
In the combo box that displays "Group By". Select Max from the list.
![](https://lh3.googleusercontent.com/-yg59nQGTDZ4/T_HARn2WsMI/AAAAAAAAGtw/oLpnjJ6aTxE/s360/play_wav3_002.png)
Your query should now look like the following picture:
![](https://lh5.googleusercontent.com/-kDQ3JKt8F6A/T_MRX-DHtWI/AAAAAAAAGvA/Ok08uShkEoM/s353/passthrough002.png)
No comments:
Post a Comment