Review the Totals for the Group

The previous page shows what the Calculated Control looks like in Print Preview, as a User would see it. What does it look like to a Programmer, in Design View?

 

Before You Begin: Change the View

Close the Print Preview, please.

When you close the Print Preview, the Report should be open in Design View, as shown.

 

6. Try it: Review the Totals in Group Footer

This Control is an expression that Counts in Genre. It can be found in the Group Footer.

 

Go to the Genre Footer.

Select the Calculated Control:

=Count([Genre])

 

Where Count is the function,

[Genre] is the Field from MovieSQ.

 

Keep going...

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Total Report Records

Home->View->Views->Design View