Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

Overdue Report

Try it: Create an Overdue Report

Go to Create->Report Wizard.

Query: rptCustomerReceiptSQ

Select these available fields:

Overdue

DateRented

Description

Price

Name

Phone

Movie

 

Group by: Overdue

 

Sort by: Name

Then by: DateRented

 

Report Layout: Landscape.

Report Title: Overdue Rentals.

 

Save this report and name it:

RptOverdueRentals.

Create ->Report Wizard
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.6. Create reports   2.6.2. Create reports using the Report Wizard