Change sorting and grouping order in a report

1. Open the report in Design view.
   
   
2. Click Sorting And Grouping on the toolbar to display the Sorting And Grouping box.
   
   
3. In the Sorting And Grouping box, click the row selector of the field or expression you want to move.
   
   
4. Click the selector again, and drag the row to a new location in the list.

If the groups you're rearranging have headers or footers, Microsoft Access moves the headers, footers, and all the controls in them to their new positions. However, you must adjust the locations of the controls in the headers and footers yourself.