O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required