2004

756 | Chapter 26 Access External Databases
Note All operators can be applied to both numeric and text-based fields. For
example, you can search for all records greater than "c", which would return all
records ranging from "ca..." through "z...". It is important to realize that query
searches are case sensitive: "ROOM" is not equivalent to "room".
The Range Query Tab
Like the Quick Query tab, the Range Query tab is designed to assist users who
are new to working with database queries. Using the Range Query tab, you
can specify a range of values for the query to return: for example, all rooms
that are greater than or equal to 80 square feet but are less than or equal to
100 square feet. The interface is similar to that of the Quick Query tab, except
the Operator field has been removed and the Value field has been replaced
with two fields; a From field and a Through field. All other interface features
are available and work as they do on the Quick Query tab.
To construct a quick query
1 Open the Query Editor as described in “To open the Query Editor” on page
754.
2 On the Quick Query tab, select a field from the Field list.
3 Select an operator from the Operator list.
4 Enter a value in the Value field, or choose Look Up Values.
Look Up Values returns a list of all values for the specified field from the
database table, so you can select the value that you want. After selecting a
value, choose OK.