Grouping and Totals

This Report has a Group Header. There is one Field: Genre. Group Totals are placed in the Group Footer. Here are the steps to show or hide the Group Footer.

 

2. Try it: Add the Group Footer

The Report, Movies by Genre, is still open in Design View and the Report Design Tools are available.


Go to
Report Design Tools ->Design.

Go to Grouping and Totals.

Click on Group & Sort.

 

What Do You See? A new pane, Group, Sort and Total will open at the bottom.

 

Group On: Genre.

Sort by: Movie.

 

Keep going...

Report Design Tools ->Design-> Grouping and Totals->Group &Sort

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Group Report Records