Microsoft® Office Access 2003 Inside Out

Defining the Sorting and Grouping Criteria

The next thing you need to do is define the sorting and grouping criteria for the report. Click the Sorting And Grouping button on the toolbar to open the Sorting And Grouping window. This report should display the daily reservation data from the query in the Detail section, with summaries of reservations by date, by month, and by facility. Note that in the Sorting And Grouping window, you specify grouping values from the outermost to the innermost (like specifying a sorting criteria left to right). So, select the FacilityName field in the first line of the Sorting And Grouping window, and then set the Group Footer property to Yes. Notice that when you set the Group Header or Group Footer property to ...