Access 2016 Intermediate

Lesson 12 - Using Advanced Report Design

Access 2010

Type the expression that calculates the result directly into the control or open the property sheet and type the expression into the Control Source property box on the Data page.

NOTE A calculated control in a form or report cannot be based on another calculated control in the form or report. However, you can base a calculated control on a calculated field in a query.



Procedures

1. Open the desired report in Design view. 2. Select the Design tab on the Ribbon .

3. Click the Text Box tool in the Controls group. 4. Click in the desired location for the control. 5. Type the desired calculated control expression. 6. Press [Enter] . 7. Select the label box paired with the control. 8. Press [Delete] .



Step-by-Step

Create a calculated control in a report.

Open the Items by Order report in Design view and display the ruler.

Scroll, if necessary, to display the Item Total column in the Page Header section.

Steps

Practice Data

1. Click the Design tab on the Ribbon . The Design tab appears.

Click Design

Page 224

OFFICEPRO, Inc.