How Do I Sort Microsoft Access Records Using Multiple Criteria?

Access enables you to sort and filter your data using any number of data fields. Whether the data you sort is in a table or is the result of a query, the user interface is the same.

Step

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.

Open Database Table
credit: Steve McDonnell/Demand Media

Step

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

Select Advanced Sorting
credit: Steve McDonnell/Demand Media

Step

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.

Select Sort Criteria
credit: Steve McDonnell/Demand Media

Step

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

Review Sorted Data
credit: Steve McDonnell/Demand Media