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!