Supress zero values based on value of other fields

[souladventurer]

Hi,

My original question was answered, thanks!

New Question.

I have 3 currency fields, ex.fields a,b,c.

I need the query to hide rows under the following conditions:
when a,b,c all have zero values
when a has a value but b and c are zero
when b has a value but a and c are zero
etc.

Thanks in advance for help!

 

[PaulBricker]

Try this. It should get you close.

Paul

SELECT MyTbl.a, MyTbl.b, MyTbl.c
FROM MyTbl
WHERE (((MyTbl.a)>0) AND ((MyTbl.b)>0) AND ((MyTbl.c)>0)) OR (((MyTbl.a)=0) AND ((MyTbl.b)>0) AND ((MyTbl.c)>0)) OR (((MyTbl.a)>0) AND ((MyTbl.b)=0) AND ((MyTbl.c)>0));