2011

Ungroup
Delete the parentheses from the selected line and from the matching ending
or beginning line of the group.
Delete
Delete the selected condition.
Clear All
Delete all conditions.
Where Condition area
Use the Where Condition area to edit an existing condition in the filter or
to add a new condition.
And
Specify that both conditions must be met for the object to be included in
the query.
Or
Specify that either condition can be met for the object to be included in
the query.
Not
Specify And Not if the first condition must be met and the second condition
must not be met for the object to be included in the query. Specify Or Not
if either the first condition can be met or the second condition cannot be
met for the object to be included in the query.
For the very first condition in the list, do not specify And or Or. You can
select Not.
Column
View columns from the current table.
Operator
Specify how to test the values in the column.
DescriptionOperator
The value of the selected column is equal to the value you enter in
the Value box.
=
The value of the selected column is greater than the value you enter
in the Value box.
>
The value of the selected column is greater than or equal to the
value you enter in the Value box.
>=
1694 | Chapter 24 External Databases Dialog Boxes