# How to Use Max Function MS Access

> To find the highest value using the max function in MS Access, open your database, go to the Create tab, and click Query Design. Next, add your table and desired field, select the Totals option on the ribbon, choose Max in the Total row drop-down, and click Run.

Canonical: https://livedemo.ai/tutorials/how-to-use-max-function-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a51eaab56e05a00ffedbf/preview?step=1

## Steps

1. Open your database.
2. Go to the 'Create' tab.
3. Click on 'Query Design'.
4. Select the table containing the data you want to analyze by clicking the 'Add Selected Tables' button.
5. Add the desired field to the query grid.
6. Select the 'Totals' option on the ribbon.
7. Go to the 'Total' row, click on the drop-down arrow and select the 'Max' option from the menu.
8. Run the query by clicking the 'Run' button.
9. That's it! You have successfully used the max function in MS Access.