Sort orders from queries

[Dave]

My query will do the sort correctly on 2 fields in
ascending order but when I go to do the report only 1 of
the fields in sorted correctly. How do you get the query
sort to transfer to the report?

 

[Marshall Barton]

My query will do the sort correctly on 2 fields in
ascending order but when I go to do the report only 1 of
the fields in sorted correctly. How do you get the query
sort to transfer to the report?

The sort order specified in the query gets lost in the
complexities of all but the most trivial reports. Report
sorting should be specified in the Dorting and Grouping
window (View menu).