Removing a row if data is blank

[Penny]

I have multiple columns in a report if all my columns have
0.00 values for a certain row how would I code my report
so that whole row doesn't show up?

Thanks in Advance

Penny

 

[John Spencer (MVP)]

could you just change your underlying query to screen out these rows?

Where Not(FieldA = 0 and FieldB=0 And FieldC = 0)

Or

Where Fielda <> 0 OR FieldB <> 0 Or FieldC <> 0