In order to summarize data in a report and override the sort order of the record source you would use: the group, sort, and total pane.
When using Microsoft Access the group, sort, and total pane are the functions and keys you would use to summarize data. There is also a shortcut section where you can search for the appropriate tools to use depending on what you need to do with your report.
