|
Calculating the Totals: The Receipt Report
will use a Select Query that groups the rental prices and calculates
the totals for each Receipt. The
Receipt Report represents a many-to-many relationship. It will be
designed as a Report and a Subreport linked by matching Keys. Plan:
This lesson will focus on Report
Design. The Report Header, the top part of the Receipt, will include the customer's
name. What Are
the Steps? The Record Source for the
Receipt Report will be a Query, rtpMovieRentedSQ, that uses the same
Table that was the Record Source for the Receipt Subform,
tblMovieRented. The
Receipt Report will be formatted as a Table and edited to fit a
small Point of Sale printer. Example of the
Record Source for the Receipt Report: rptReceiptSQ, a Query |
|
| |
