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!