The Overdue Letter
Let's walk
through the Report Wizard to create the Overdue Letter. We will use
rptOverdueSQ as the Record Source.
1.
Try it: Use the Report Wizard
Go to
Create ->Reports->Report Wizard.
Select
a Record Source: rptOverdueSQ.
Select
these available Fields:
FullName
Address1
CityStateZip
Movie
Description
DateRented
DaysRented
Rental
View
the Report By: tblCustomers.
Group
By: DateRented.
Sort
By: Movie.
Orientation: Portrait.
Save
this Report as rptOverdue.