graphci2
graphci1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.3 Format a Report: Add Calculated Fields (Use the Expression Builder)

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