
This MS Access tutorial explains how to use Access SQL to select MAX record (MAX row) of each group.
Access SQL select MAX record
In Microsoft Access, you can select fields you need to Group and then use MAX to get the max record of each Group. However, the result only returns the grouped fields but not all the fields in the original table. In this tutorial I will show two methods to select all fields.
Example - Select Max data
Table1 below stores the performance rating of each employee in d...
Read More