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.

Create ->Reports->Report Wizard

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.1. Create reports: Use the Report Wizard