Use a Query in a Query
This Query
is linked to tblCustomers. We have a Query that already combines the
name and address Fields. We can use that Query instead of
tblCustomers.
Before You Begin: Delete a Table
Select a
Table: tblCustomers.
Click
DELETE on your keyboard. Bye bye.
6.
Try it: Add a Query
Go to
Query Tools ->Design->Show Table.
Go to Queries.
Select a Query:
CustomerNameSQ.
Click
Add.
Close the Show Table
Window. Keep
going...