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.

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

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.