|
The Record
Source for the Receipt Printout will be a Query,
rtpMovieRentedSQ, that
uses the same Table that was the Record Source for the Receipt
Subform, tblMovieRented. This Table has Key Data
that says who bought what? Here is the plan: Review
the Record Source: tblMovieRented
Open tblMovieRented in
Design View.
Identify the Key Fields.
Create a Query:
rtpReceiptSQ
Add tblMovieRented and
related Tables.
Create JOINS between the
Tables.
Group the Records by Receipt.
Calculate the Amount Due for
each Receipt. Create
the Report: rptReceipt-POS The
rptReceipt-POS will be a Tabular Form formatted as a Table.
The Report will be sized to fit a POS printer. That's the
plan for now.
|
|
| |
