query with conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with 3 calculated fields. I want to be able to exclude any
record where all three calculations are equal to 0, and include any records
where any one of the three has a value greater than 0, and I am completely
stumped as to how to accomplish this. Any help that you can provide will be
greatly appreciated.

Thanks!!
 
In the criteria put...

<>0

for each field.

Placing this on the same line for each will create an AND statement.
Placing them on separate lines will create an OR statement. Since you want
to show any record where calculation 1 is not zero OR calculation 2 is not
zero OR calculation 3 is not zero, you'd want these three criteria on
separate lines at the bottom of the query design view.
 
Back
Top