Calculate a total or other value for one record on a grouped data access page

1. Open the data access page in Design view.
   
   
2. If the expression will reference field names, then the fields need to be in the page's data definition. Either add the fields to the page as bound HTML controls, or add the fields as bound text boxes.

   Tip   The page will load faster in Page view and in Microsoft Internet Explorer if you use bound HTML controls.

3. Create another control by clicking the Bound HTML tool or the Text Box tool in the toolbox, and then releasing the mouse button where you want the upper-left corner of the control on the page.
   
   
4. To display the property sheet, make sure that the control is selected, and then click Properties on the toolbar.
   
   
5. In the ControlSource property box, type an alias and an appropriate expression. To reference fields on the page, use the names of the fields in the expression. For example, if you want to compute the extended price for a record in the Order Details table, type:

   ExtendedPrice: UnitPrice*Quantity

   If you don't specify an alias, you must type an equal sign (=) before the expression. Access will automatically supply an alias; for example, Expr1.

Notes  

• If you don't want to display the values in the fields used in the expression in Page view or Internet Explorer, you can hide the controls or delete the controls. Even if you delete the controls after you define the expression, the fields will still be in the page's data definition.
  
  
• If a page is based on a query, you can put the expression in the page's underlying query. If you are going to calculate totals for groups of records, it's easier to use the name of a calculated field.
  
  
• See examples of other expressions you can use to calculate values for one record.
  
  
• Learn more about creating expressions in a Microsoft Access database (.mdb).
  
  
• Learn more about creating expressions in a Microsoft Access project (.adp).
  
  
• To do complex calculations using spreadsheet functions, use the spreadsheet control.