|
The
Receipt Form will look up a customer's phone number. The
CustomerNameSQ should include a phone number as well.
3.
Try it: Edit the CustomerNameSQ Go to
tblCustomers.
Double-click a Field: HomePhone. What Do
You See? The HomePhone Field should be added to the QBE Grid on
the bottom of the Query. Do
This, Now: Save the Query Go to
File->Save. Close
the CustomerNameSQ Query.
This Query will be used as the Record
Source for the Receipt Form.
Query Tools ->Design
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.3. Manipulate fields: Add a Field |
|
| |
