|
Administrator: Receipts
All queries need data output. Add the following
fields to the grid:
From tblMovieRented:
ReceiptID
DateRented
From tblRental:
Price
Description
From tblCustomers:
LastName
FirstName
Address1
Address2
City
State
Zip
Phone
From tblMovieTitles:
Movie
|
|||
|
| |||
Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries
4.1. Create queries
4.1.1. Create queries based on single tables: Add fields to queries