Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Add a Calculated Control

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

Add a Calculated Control

Our goal is to add Totals for each Group as well as for the entire Report. Basically, a Total is a Text Box that has an expression instead of a Control Source.


It is a Calculated Control: an Expression that Counts the Records in each Group.


4. Try it: Create a Calculated Control

Go to Group, Sort and Total.

Select a Group: Genre.

Edit the Totals as follows:

Total on: Genre.

Type: Count Values

Show subtotal in Group Footer.


Keep going...