How to design this query?

[smith]

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]

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

 

[smith]

But how to design this query?please

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

 

[Duane Hookom]

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