Why Multiple-Field Sorting in Access Query Design Appears to Fail
Question details
Understand how to control the priority of multiple sort fields in an Access query.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user wants to sort query results by company and then by city using the query design grid.
- Observed behavior
- Access sorts by the leftmost sort field first; later fields determine the order only when earlier field values match.
Open the query in Design View and identify the fields with values in their Sort row. Decide which field should determine the primary order of the results.
Set the Sort Priority in the Access Query Design Grid
Arrange the sort fields from left to right in priority order to get the intended hierarchical sort.
In the Navigation Pane, right-click the query and select Design View.
In the design grid, move the highest-priority sort field to the left of the other sort fields. For example, place Company before City.
In the Sort row, select Ascending or Descending under Company, then choose a direction under City.
Select Run on the Query Design ribbon and check the results. City is sorted only among records with the same Company value.

Review Exported Access Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with exported data. Open an Excel export from Access in WPS Spreadsheets for an easy transition, but use Access to change the original query design.

Frequently Asked Questions
Why isn't City sorted alphabetically across the whole query?
If Company is the leftmost sort field in Design View, Access sorts companies first. City is sorted only within rows that have the same Company value.
How do I make City the primary sort field?
Open the query in Design View, move City to the left of Company in the design grid, and choose Ascending or Descending in its Sort row.
Can I use different sort directions for the two fields?
Yes. In Design View, choose a direction in the Sort row for each field, such as Ascending for Company and Descending for City.
Can WPS Office change the sort order of an Access query?
No. Change the query in Microsoft Access. You can export the results to an Excel file and open that file in WPS Spreadsheets for further review.




