How Do I Sort Microsoft Access Records Using Multiple Criteria?

Open your database in Access. In the left column, display the data you want to sort by double-clicking the name of the table containing the data. For example, the data in the Province table below contains data on each country and its provinces. The sample data is courtesy of The MONDIAL Database, Institute for Informatics, Georg-August-Universität Göttingen.

Select Advanced from the Database Tools section of the ribbon bar and then choose Advanced Filter/Sort...

For each level of sort you want, choose the data field by which you want to sort in the Field row, and then choose Ascending or Descending in the Sort row. Select Toggle Filter to apply the sort to the data table. The example below sorts the province data alphabetically by country and then by population within country, largest to smallest.

Review the data to ensure it's sorted properly, and modify your sort and filter conditions as necessary.