Open your database in Access, open the report in Design View. Then click on the View menu, click Sorting and Grouping. Once the dialog box appears select a field name or type an expression. You can sort up to 10 fields/expressions in a report. The first row is the first sorting level and so on from each row following.