O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required