Add a Calculated Control

This Report can calculate the number of days each movie is past due. Here are the steps.

 

6. Try it: Add a Calculated Control

Go to Report Design Tools ->Design->Controls.

Select a Control: Text Box.

Click on the Detail Section to create the Control.

 

Now, Do This: Edit the Properties

The Unbound Text Box is selected.

Go to Property Sheet->All.

Edit the Name: PastDue

 

Try This, Too: Edit the Control Source:

Click on the Control Source (It is blank).

Click on the three-dot builder to open the Expression Builder.

 

Select an Expression Element: rptOverdue.

Select the Categories to create the expression:

=[DaysRented]-[Rental]

 

Click OK. So...what did that do?

Report Design Tools ->Design->Controls->Text Box

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Add Bound and Unbound Controls