RexesOperator
Registered User.
- Local time
- Today, 08:30
- Joined
- Jul 15, 2006
- Messages
- 604
I have set up a report that allows a contact to have a different mailing address than the company's. I have an invisible text box that controls an IIF statement:
=IIF ([txtbox] = "Y", [CompanysAddress], [ContactsMailingAddress])
This works, but is there a more elegant way of doing this in a report?
=IIF ([txtbox] = "Y", [CompanysAddress], [ContactsMailingAddress])
This works, but is there a more elegant way of doing this in a report?