Multiple Mailing Addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top