Datasheet

Figure 1-27 Each line of criteria will be evaluated separately.
Using operators in queries
You can filter for multiple criteria on any given field by using operators. The
following operators allow you to combine multiple values in different logical
contexts so that you can create complex queries.
Or
Either condition can be true. Multiple criteria values for one field can either be
separated by a criteria line or combined in one cell with the use of the Or oper-
ator. For example, using your query, you can filter for both California and
Colorado by typing “CA” or “CO” in the criteria field.
Between
Tests for a range of values. For example, using your query, you can filter for all
invoices between 4/20/2004 and 11/19/2004 by typing “Between #4/20/2004#
and #11/19/2004#” in the criteria field.
Like
Tests for string expression matching a pattern. For example, you can filter for
all records with a customer number that begins with the number “147” by typ-
ing “Like “147*” in the criteria field. The asterisk is the wildcard character that
can signify any character or combination of characters.
Access Basics 35
05_59978X ch01.qxp 12/1/05 7:46 PM Page 35