O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required