Why can I set this criteria?

[smith]

I can't set the "or". Please give me detailed instructions.
Please refer to the following:

Open a new query with your table as the source. Set the criteria under the
FieldA column like:

[Field B]
[Field C]

Make sure you use two lines in the criteria grid to get an "OR" rather than
an "AND".

 

[John Vinson]

I can't set the "or". Please give me detailed instructions.
Please refer to the following:

Open a new query with your table as the source. Set the criteria under the
FieldA column like:

[Field B]
[Field C]

Make sure you use two lines in the criteria grid to get an "OR" rather than
an "AND".

Just do exactly what Duane suggested.

Put one criterion on the first Criteria line underneath FieldA.
Put the second criterion on the second Criteria line, underneath the
first one.

Access will see that these two criteria are on separate lines and use
OR logic (so that the record will be found if FieldA matches FieldB,
or if it matches FieldC, or if it matches both).


John W. Vinson[MVP]