Count the Movies

Your goal was to count how many comedies, westerns and dramas are in the Front Row Video database.

 

8. Add the Totals

Go to Grouping and Totals

Click on More to expand the code.

Select: with Movies Totaled.

Show the group totals.

 

9. Review the Count Properties

Select the Genre Control.

Go to the Property Sheet.

 

This is a Text Control.

The Control Source is:

=Count([Movie])