Removing a row if data is blank

  • Thread starter Thread starter Penny
  • Start date Start date
P

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
 
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
 
Back
Top