Move Check Boxes together in a report

[Denise]

I have a report with 80 yes/no fields with check boxes. I
only want the fields that are marked off YES to show up on
the report and moved together.

Thanks,

Denise

 

[Rick Brandt]

I have a report with 80 yes/no fields with check boxes. I
only want the fields that are marked off YES to show up on
the report and moved together.

You likely should have designed your tables so that you would have 80 *rows* instead
of 80 fields. Then it would be easy to filter on only the Yes values.