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?