Multiple Mailing Addresses

[Guest]

I have a database for contacts for our company. In the database there is a table that has the contact's name and address and a mailing address if it is different than the other address. How can I create a report that will print the contacts name and mailing address and or their name a regular address if they don't have a different mailing address. Do I need a seperate table to make this possible?

Any help would be greatly appreciated

Thanks

 

[Guest]

You can use an immediate if statement in the query behind the report

The one field name in the query would look like

Address: IIF(IsNull([MailingAddress]),[Name] & " " & [RegularAddress],[Name] & " " & [MailingAddress]

Then just use the [Address] field in the report. You will have to expand the name, mailing, and regular address fields to include all the lines you need and you can insert " & Chr(13) & Chr(10) & " for line returns where appropriate.