|
We want to
display the customer's name and address on the screen after we look
up the phone number. We already have a Query that combines
(concatenates) these Fields.Let's see if it meets our needs.
2.
Try it: Review the Customer Query Go to
All Access Objects ->Queries. Open a
Query: CustomerNameSQ. Try
This, Too: Change the View Go to
Home->Views->View. Select a
View: Design View. What Do
You See? The Query has one Table: tblCustomers. In addition to
the CustomerID, FirstName and LastName. there are three Fields which
combine (concatenate) the name and address: FullName
LastNameFirst
CItyStateZip Keep
going...
All Access Objects ->Queries
|
|
| |
