How to Use Max Function MS Access
- George Apostolov
- 05 Sep 2025
Guide
Open your database.
Go to the 'Create' tab.
Click on 'Query Design'.
Select the table containing the data you want to analyze by clicking the 'Add Selected Tables' button.
Add the desired field to the query grid.
Select the 'Totals' option on the ribbon.
Go to the 'Total' row, click on the drop-down arrow and select the 'Max' option from the menu.
Run the query by clicking the 'Run' button.
That's it! You have successfully used the max function in MS Access.
Create your first interactive demo in minutes
No credit card required • Start building today
