Yes/No fields on a report

[seamusnboo]

Hi.

I need to create this report from a table that has several YES/NO type of fields. On my report tho, I only want the report to show the data that has YES on the field, and the ones that has NO not to be shown. How can I do that?

Thanks

 

[mpb.vu2]

?
why not using a query?

 

[chubby-gal]

You can use the IIF method, on the text box control source, use =IIF([NameField]=1,[NameField],"")