graphic2
graphic1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.2 Set Report Controls: Group Data by Fields

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

graphic3