Quick summary
Sorting query results in MS Access lets you organize database records in ascending or descending order directly from the query design grid. This tutorial walks you through opening Design View, setting a sort order on a field, and running the updated query to view sorted output.
Steps
- Go to the Navigation Pane, right-click your query, and select Design View.
- Locate the field you want to sort in the query design grid and set the sort order.
- Click Save, then run the query to see the sorted results.
