How to Use Min Function MS Access

Quick summary

The Min function in MS Access returns the lowest value from a specified field using a Query Design. You can apply it in just a few steps by enabling the Totals row and selecting Min from the aggregate drop-down.

Steps

1. Open your Access database.
2. Select Query Design to start building a new query.
3. Select a table and click Add Selected Tables to add it to the query.
4. Drag the field you want to evaluate into the query grid.
5. Click the Totals button on the ribbon to enable aggregate functions.
6. Click the drop-down arrow and select Min from the drop-down list for the field.
7. Run the query by clicking the Run button to execute and view results.
8. You have successfully used the Min function in MS Access to return the lowest field value.