Use the Record Sort Order dialog box to define how you want the records in your report to be sorted for printing. A sort field is a data field on which the sort procedure is based. You can add and remove sort fields and define the sort direction (ascending or descending) for the data in your report.
This dialog box appears when you right-click in the Report Designer, point to Report, and click Record Sort Expert.
Grouping, Sorting, and Totaling Data | Hiding Details in Summary Reports | Design Choices to Optimize Performance