2012

Construct Simple Queries
The simplest query uses one operator to search one field for a certain value.
The range query searches one field to return records that fall within a range
you specify.
The Quick Query Tab
The Quick Query tab is designed to familiarize you with query syntax as quickly
as possible. Constructing a quick query involves selecting a field from the
current database table, applying a conditional operator to it, and specifying a
value for the field.
Conditional operators are constraints such as equal, greater than, or less than.
The following table summarizes the Quick Query tab's operators.
Query Operators
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 open the Query Editor
1 Click Toolsmenu ➤ Palettes ➤ DbConnect.
2 In the dbConnect Manager, in the tree view, select a database table.
3 Click the New Query button.
4 In the New Query dialog box, enter a name for the query in New Query
Name.
5 Click Continue to open the Query Editor.
2034 | Chapter 39 Access External Databases