0.00's in Columns Help

[Guest]

Hello,

I have a table where there are 0.00's in column one and 0.00's in column
two. when I run my query, I want to be able to see the information without
the 0.00 in column one and two. Example:

column1 column2
2.0% 0.69%
5.0% 8.0%
0.00% 0.00% *do not want to see this row*

Thanks in Advance

I just

 

[Guest]

Use criteria
WHERE Sum(Nz([column1]) + Nz([column2])) >0

 

[Van T. Dinh]

Add a criterion like:

.... WHERE (([Col1] + [Col2]) > 0)

If you have Null value(s), try:

.... WHERE ((Nz([Col1], 0) + Nz([Col2], 0)) > 0)

 

[John Vinson]

Hello,

I have a table where there are 0.00's in column one and 0.00's in column
two. when I run my query, I want to be able to see the information without
the 0.00 in column one and two. Example:

column1 column2
2.0% 0.69%
5.0% 8.0%
0.00% 0.00% *do not want to see this row*

Thanks in Advance

I just

Just put criteria

<> 0

on both columns.

The suggestions to sum the columns and check the sum will *probably*
work unless you have negative values - if Column1 is 2.0% and Column2
is -2.0% you'll get a zero sum!

John W. Vinson[MVP]