Datasheet
Figure 1-24 Run this query to examine the results.
Refining the query further
You can narrow down your results even further by filtering the query results
according to a certain date. As you can see, there are several rows of criteria
cells. These allow you to enter multiple criteria from which to filter. One thing
to keep in mind is that each separate criteria row functions as its own separate
set of criteria. Take a look at how this works.
Figure 1-25 The results of the query have successfully brought together
and matched data from two separate tables.
Access Basics 33
05_59978X ch01.qxp 12/1/05 7:46 PM Page 33