|
Administrator: Receipts
Who Bought What?
The
Front Row Video database
sample has a customer receipt query that can answer many
business questions.
Before you begin:
Make a copy of the query
The following demonstrations are based on a sample
query: rptCustomerReceiptSQ.
Right click the query and make a COPY.
Name it: SalesSQ.
Try it: Edit the Query
Open SalesSQ in Design View
Delete the customer table: tblCustomer.
Did all of the customer name and address fields
disappear from the grid, too?
Delete the concatenated fields, too.
Look, there are two combined fields, one for FullName and other for
CityStateZip. These
concatenated fields still
refer to the Customer table. Delete these two fields.
|
|||
|
| |||
