Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make real-time report

Status
Not open for further replies.

alansbiz

Programmer
Dec 23, 2002
3
US
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"). 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.
 
Try putting something like this in a textbox on your report.

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

See if that does it.

Paul
 
Thanks Paul. Thas was very helpful. I actually moved the IIF statement to a query.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top