|
Most
businesses are date driven. For example, these movies are rented for 1,
3, or 5 days. If the movies are not returned as agreed, the customer
could be notified which movies are overdue. These business rules can be
programmed into our Mighty Access database. A Query can calculate the
difference between the date the movie was rented and the current date.
This lesson
begins by creating the Record Source for the Overdue Movie Report, a Query that calculates the
numbers of days that each movie is overdue. The Report
will be Grouped by Customer and formatted so that there is only one
customer per page.
So, our tardy
customers get an Overdue Movie Report that is formatted like a
letter. |
|
| |
