3. Double-click Create Query in Design View.
The Query editor and the Show Table dialog box (see Figure 2-16) both
appear.
4. Select the tables you want to use in your quer y and click the Add
button.
5. Click the Close button to close the Show Table dialog box so that you
can work in the Quer y editor.
6. Add the fields to the lower pane of the Quer y editor.
You can drag-and-drop them or choose them from the drop-down Field
list box.
7. Optionally, choose a sort order for any of the fields.
8. Leave the Show check box selected for any fields you want to display
in the results and deselect it for any fields you don’t want to see in the
results.
9. Enter any criteria you want to use to select the records to include in
the results.
10. Repeat Steps 6 through 9 until you have added all the fields and crite-
ria that you want to include.
Figure 2-17 shows the completed query I created for this example.
11. Click the Run button or choose Quer y.Run to run the query.
Figure 2-18 shows the results of running the query shown in Figure 2-17.
Figure 2-16:
Use the
Show Table
dialog box
to select the
tables to
use in your
query.
41
Chapter 2: Getting Started with Queries
06_599658 ch02.qxd 8/31/05 12:43 PM Page 41
|
|