Calculate a total for one record in a report

1. Open the report in Design view.
   
   
2. Add a calculated text box to the detail section.

   How?

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 appropriate expression.

   

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

Notes  

• If a report is based on a query, you can put the expression in the report's underlying query. It may improve the report's performance, and if you are going to calculate totals for groups of records, it's easier to use the name of a calculated field in an aggregate function. For more information, click .
  
  
• For examples of other expressions you can use to calculate values for one record, click .
  
  
• For more information about creating expressions in a Microsoft Access database (.mdb), click .
  
  
• For more information about creating expressions in a Microsoft Access project (.adp), click .