One-to-Many: Report
Design
Report Totals and
Options
Key
Concept: Add a Calculated Control to the
Group Footer to show Totals.
Purpose:
Use Sorting and Grouping to show
One-to-Many relationships in a Report.
What Are
the Steps?
Create a
Report based on a Query.
Add Sorting
and Grouping
Group the
Movies by Genre
Sort the
Movies by Year
Add
Totals to the Report
Total Each
Group
Total for
the Report
Grab the cookies.
Let's get started!