Make real-time report

[alansbiz]

I want to omit certain text fields on a report based on if they are selected in the table. I have several fields in a table that are boolean ("yes/no&quot. If they have been selected I want to add text to the report saying, "Field1 has been selected". If the field hasn't been selected, I don't want to do anything.

 

[PaulBricker]

Try putting something like this in a textbox on your report.

=IIf([Field1]=-1,"Field 1 has been selected","&quot

See if that does it.

Paul

 

[alansbiz]

Thanks Paul. Thas was very helpful. I actually moved the IIF statement to a query.