• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 14. Presenting Data with Access > Performing Calculations in Reports

Performing Calculations in Reports

When you create a report, you might want to include summary information or other calculations. The wizards often include built-in functions, but you can use the Expression Builder to create your own by clicking buttons for the arithmetic operators you want to use and including constant values as needed. For example, if you want to determine staff bonuses based on a percentage of overtime hours worked, you can create an arithmetic expression to compute the results. When you generate the report, Access will perform the required calculations and display the results in the report. To display the calculations in the appropriate format, you can also use the Properties feature to specify formats for dates, currency, and other numeric data.

Choose Fields to Use in a Calculation

In Design view, create a text box control and position it where you want the calculated field to appear, or select an existing unbound control.

Click the Properties button on the Report Design toolbar.

Click the Control Source property box, which specifies what data appears in a control, and then click the Expression Builder button.

Click the equal sign (=) button.

Enter the values and operators you want to use.

  • Click operator buttons to supply the most common operations.

  • Double-click folders in the left pane to open lists of objects you can use in your expression, including existing fields, constants, operators, and common expressions.

  • Manually type an expression.

Click OK to insert the calculation.

Click the Close button.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint