2011

And specifies that both conditions must be met for the object to be included
in the query.
Or specifies that either condition can be met for the object to be included
in the query.
And Not specifies that the first condition must be met and the second
condition must not be met for the object to be included in the query.
Or Not specifies that either the first conditions can be met or the second
condition cannot be met for the object to be included in the query.
Column list
Select a column from the list.
The list displays columns from the current table.
Operator list
Select an operator from the list.
DescriptionOperator
The value of the selected property or data is equal to the value
you enter in the Value box.
=
The value of the selected property or data is greater than the
value you enter in the Value box.
>
The value of the selected property or data is greater than or equal
to the value you enter in the Value box.
>=
The value of the selected property or data is less than the value
you enter in the Value box.
<
The value of the selected property or data is less than or equal to
the value you enter in the Value box.
<=
The value of the selected property or data is not equal to the
value you enter in the Value box.
<>
The value of the selected property or data matches any of the
values you enter in the Value box. When you use the IN operator,
IN
you must enclose each value in single quotation marks, separate
the values with commas, and enclose the entire list in parentheses,
for example, ('1','2','3').
The value of the selected property or data is empty. Do not enter
a value in the Value box.
IS NULL
1868 | Chapter 33 Query Dialog Boxes