Calculate a total or average for a group of or all records in a report

1. Open the report in Design view.
   
   
2. Add a calculated text box to one or more of the following sections:

   How?

   • To calculate a total or average for a group of records, add a text box to the group header or footer.
     
     
   • To calculate a grand total or average for all records in the report, add a text box to the report header or footer.
3. To display the property sheet, make sure the text box is selected, and then click Properties on the toolbar.
   
   
4. In the ControlSource property box, type an expression that uses the Sum function to calculate a total or the Avg function to calculate an average.

   

   Tip   In a Microsoft Access database (.mdb), you can click the Build button to use the Expression Builder to create the expression.

Notes  

• For more information about creating expressions in a Microsoft Access database (.mdb), click .
  
  
• For more information about creating expression in a Microsoft Access project (.adp), click .
  
  
• For more information about calculating totals and averages using aggregate functions such as Sum and Avg, click .
  
  
• For examples of expressions that use aggregate functions, click .
  
  
• The Employee Sales by Country report in the Northwind sample database has an example of group totals and a grand total. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Employee Sales by Country report in Design view. For information about opening Northwind, click .