Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Case Example

In the following example, you create a query with contact info and use it in a mail-merge Word document. The finished letter is shown in Figure 13.30.

1.	In the Database window, select tblCustomersSalutation.
2.	Choose Insert, Query. With Design View selected in the New Query dialog box, click OK.
3.	In the field list, click CustSalutation. Press Shift and click CustZIP. Drag the seven fields to the design grid and drop them.
4.	Click in the Criteria row of the CustState field and type ca. This limits the recipients to only those customers who live in California.
5.	Choose File, Save. Name the query qryCaliforniaCustomers and click OK. Click View to see the records. Close the query.
6.	In the Database window, click Queries.
7.	Select ...