Datasheet

In
Similar to Or. Tests for all records that have values that are contained in paren-
theses. For example, you can filter for both California and Colorado by typing
“In (“CA”, “CO”)” in the criteria field.
Not
Opposite of writing a value in criteria. All records not matching that value will
be returned. For example, you can filter for all states except California by typ-
ing “Not “CA”” in the criteria field.
Is Null
Filters all records that have the database value Null in that field.
The traditional mathematical operators allow you to construct complex cri-
teria for fields, which are used in calculations: =, <, >, <=, >=, and <>.
For example, if you want to further refine your query so that only invoice
amounts over $200 will be returned in the results, use the greater-than operator
to filter the Sales_Amount, as shown in Figure 1-28.
After running the query, you can see that you narrowed down the results to
just six records. These are the only records that match the multiple criteria,
which were designated in the QBD. Figure 1-29 shows the query results.
Figure 1-28 You can use operators to test for ranges of values.
36 Chapter 1
05_59978X ch01.qxp 12/1/05 7:46 PM Page 36