1-866-245-5224 sales@keystonelearning.com

Access 2007: Working with Total Fields

Access 2007: Working with Total Fields

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.

     
  1. Open a Report in Layout View
     
  2.  
  3. Select the field you want to summarize
     
  4.  
  5.  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.

     
  1. Open a Report in Design View
     
  2.  
  3. Choose the Text Box command in the Controls group on the Report Design Tools Design Contextual tab
     
  4.  
  5. Click in the Section that you want your total field to display
     
  6.  
  7. Select the Text Box
     
  8.  
  9. Pres [F4] (the Property Sheet is displayed)
     
  10.  
  11. 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