# How to Sort Query Results MS Access

> To sort query results in Microsoft Access, open the query in Design View from the Navigation Pane. Next, locate the desired field in the query design grid and set the sort order. Finally, click Save and run the query to view the newly sorted results.

Canonical: https://livedemo.ai/tutorials/how-to-sort-query-results-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4ee7ab56e05a00ffad2f/preview?step=1

## Steps

1. Go to the 'Navigation Pane', right-click your query, and select 'Design View'.
2. Locate the field you want to sort in the query design grid and set the sort order.
3. Click 'Save', then run the query to see the sorted results.