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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude Multiple Zeros in Query 4
quandary on selecting certian records 4
IIF Function Within A Query 6
Creating a total query 4
Count expression in a Query? 3
How do I run a query using multiple conditions? 1
WHERE mystery 2
Limit the results from a calculated field in a query 7

Back
Top