2012

List of Options
The following options are displayed.
Query Builder Grid
Provides a space for you to construct queries based on multiple search
parameters.
Parenthetical Grouping Groups a series of search criteria by bracketing them
within parentheses. You can nest up to four sets of parentheses within a single
statement. To insert a beginning parenthesis, click in the cell to the left of the
first Field cell that you want to group. To insert an end parenthesis, click in
the cell to the right of the last Value cell that you want to group.
Field Provides a space where you can select the field or fields to include in
your query. Double-click in the Field cell of the current row to display a list
of available fields from the current database table that you can use in
constructing your query. To add an additional parameter, specify an operator
and a value for the current row and then select the Logical cell.
Operator Provides a space where you can select an operator to apply to the
query condition of the current row. Double-click in the Operator cell to display
a list of operators that you can use in constructing your query.
Value Provides a space where you can specify a value for the query condition
of the current row. Click in the Value cell and enter a value, or choose the [...]
button to retrieve a list of available values for the selected field in the
Column
Values dialog box
.
Logical Provides either an And or an Or operator to the query statement.
Click in the Logical cell to add an And value. To change the value to Or, click
in the Logical cell again.
Query Editor | 473