|
The Record
Source for the Overdue Movie Letter will be a Query,
rtpOverdueSQ, that
will calculate the number of days from the date the movie was rented. Here is the plan:
Create a Query:
rtpOverdueSQ
Add tblMovieRented and
related Tables.
Create JOINS between the
Tables.
Group the Records by
Customer.
Calculate the Amount Due for
each Customer. Create
the Report: rptOverdueMovie rptOverdueMovie
will be formatted as a
business letter: one page per customer. That's the
plan for now.
|
|
| |
