When you sort on two fields in Query Design view, the sorted fields must appear next to each other in the query grid.

Name: When you sort on two fields in Query Design view, the sorted fields must appear next to each other in the query grid.
Brand: Quizplus
Rating: 4.8 (43 reviews)

Question

Quizplus · Accepted Answer

In Query Design view, fields do not need to be adjacent to each other in the query grid to be sorted. You can specify sorting order for non-adjacent fields independently.

When You Sort on Two Fields in Query Design View