Others

Why Multiple-Field Sorting in Access Query Design Appears to Fail

Phi Hung VoPhi Hung Vo Nov 14, 2026 869 views

Question details

Understand how to control the priority of multiple sort fields in an Access query.

Why Multiple-Field Sorting in Access Query Design Appears to Fail
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the query design

In the Navigation Pane, right-click the query and select Design View.

2
Place the primary sort field first

In the design grid, move the highest-priority sort field to the left of the other sort fields. For example, place Company before City.

3
Set each sort direction

In the Sort row, select Ascending or Descending under Company, then choose a direction under City.

4
Run the query

Select Run on the Query Design ribbon and check the results. City is sorted only among records with the same Company value.

Set the Sort Priority in the Access Query Design Grid
Sorting is hierarchical: A city may appear out of alphabetical order across different companies because the Company field takes priority. Put City first if you want cities sorted across all records.
Free Microsoft Office alternative

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.

Review and sort exported company and city data in a spreadsheetOpen and edit Microsoft Excel XLSX filesWork in a familiar, easy-to-use interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

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.