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!