How to design this query?

smith · Oct 11, 2006

In the condition that Data in Filed A> Field B or Field A > Field C, Data
in all fields is visible when I run the query.

How to design this query?

Duane Hookom · Oct 11, 2006

Data should be visible in all fields. Queries filter out records, not
fields.

smith · Oct 11, 2006

But how to design this query?please

Duane Hookom said:
Data should be visible in all fields. Queries filter out records, not
fields.

Duane Hookom · Oct 11, 2006

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".