filter out zero's across a record set 1

[MICKI0220]

I need to suppress any row that the value fields in the detail section are all zero's. We only want to see the records where activity has happened.

 

[dhookom]

I would do this in the Record Source of the report.

WHERE Abs(FieldA) + Abs(FieldB) + Abs(FieldC) + Abs(FieldD) + Abs(FieldE) <> 0

Having multiple value fields where you need to perform calculations across the fields suggests an un-normalized table structure. I could be wrong in your case.

Duane
Hook'D on Access
MS Access MVP

 

[MICKI0220]

Thank you dhookum, that was what I needed.