Example of a Calculated Control in a Microsoft Office Access 2010 Report What Are the Objectives? This Report will be based on a Query that was made in an earlier lesson: MoviesSQ. This Query looks up information from tblMovies.   Here are the objectives for this lesson:   Create a Report based on a Query Review the Query   Create a Report with the Report Wizard Select MoviesSQ Query as the Record Source   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   That's our goals for this lesson. There may be one or two more by the time we are done.