You can create totals on individual fields, or controls, without having to create an entire group or summary report.
Adding a Total Field in Layout View
Layout view provides you with the quickest way to add totals, averages, and other aggregates to your report.
Open a Report in Layout View
Select the field you want to summarize
Choose the Totals command in the Grouping & Totals group on the Report Design Tools Formatting Contextual tab
Figure 75. Totals Drop Down List
4. Select the appropriate function
Adding a Total Field in Design View
Design view gives you a bit more control over the placement and appearance of your totals. In grouped reports, you can put totals or other aggregates in the header or footer of each group.
Open a Report in Design View
Choose the Text Box command in the Controls group on the Report Design Tools Design Contextual tab
Click in the Section that you want your total field to display
Select the Text Box
Pres [F4] (the Property Sheet is displayed)
Click the Data tab
Figure 76. Property Sheet - Data Tab
7. Type the expression in the Control Source property box
8. Close the Property Sheet
9. Save & Preview the Report