Microsoft® Office Access™ 2007 Plain & Simple

Calculating Values in a Report

When you create a report, you can create a control (such as a text box) that performs a calculation on the values elsewhere in the report. For example, if a report record had a field for a product’s Price and another field noting the Quantity ordered, you can create a control that multiplies the values from those fields and displays the result. Creating calculated fields in a report is handy when you work with a popular query and you don’t want Access to recalculate the values every time the query is run.

Create a Calculated Field

1. Open a report in Design view.

2. If necessary, click the Design tab.

3. Click the Text Box control. ...