I am working on a report to send to all of our clients. We have a query set up that list both street address and mailing address in separate columns and a yes/no column to check if mailing address is different.
What I want the report to do is if the yes/no box is checked “yes” then to print “ In reference to:”+[PropertyAddress1] and if not checked then print nothing.
This is what I entered and it’s not right:
=IIF([mailing_address_different]=”yes”, “In reference to:” + [PropertyAddress1], “”)
Any ideas?