Do not show fields with a value of "No"

[Albert]

Hello


I am working on a query and a report where I have a lot of different fields that have a Yes or No as the data, but not a null value.
I want to not show the fields with 'No' and only have the fields with Yes showing in the report.
Its not a null value, but the text 'yes' or 'no' that is in the fields.
Any help as allways appreciated.

I work for a non profit organisation so I am limited in my knowledge of Access
A

[June7]

Can't do that with normal functionality. Would require elaborate VBA code to dramatically modify the report 'on-the-fly'.

[Albert]

thank you
I will just have to go the the original showing all
A