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

1. Open the data access page in Design view.
   
   
2. If they aren't already on the page, add the controls that will contain the data you want to use in the calculation.
   
   
3. Click the Office Spreadsheet tool in the toolbox, and then release the mouse button where you want the upper-left corner of the spreadsheet control on the data access page.
   
   
4. In any cell in the spreadsheet, enter a formula that uses the HTML Document function to refer to the fields used in the calculation, and the specific operation you want to perform on the field's values expressed as a combination of operators, identifiers, and values.

   Example   To multiply the value in the Quantity field by the value in the UnitPrice field, type:

   =document.Quantity.value*document.UnitPrice.value

   Example   To multiply the value in the UnitPrice field by a percentage rate stored in spreadsheet cell C1, type:

   =$C$1*document.UnitPrice.value

Notes

• To see the name of a spreadsheet, select its control, and then display the property sheet. The property sheet title bar displays the spreadsheet name.
  
  
• See more examples of formulas that refer to controls on a data access page.
  
  
• You can use spreadsheet functions, which, in Microsoft Access, are only available in this control.
  
  
• Most likely, you'll want the calculated value to display in an area that looks like the other controls on the data access page. To do this you can modify the appearance of the spreadsheet control so it looks like a text box control.