multiple mailing addresses

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

Guest

I have created a database to track companies we donate to. However some of the companies have a different mailing address. I need to be able to send monthly letters to the companies. I want the write a query that will sort through the fields and use the mailing address if one is entered and if not use the regular address.
Any suggestions and help would be appreciated

Thank

Amy
 
I have created a database to track companies we donate to.
Click to expand...
However some of the companies have a different mailing address. I
need to be able to send monthly letters to the companies. I want the
write a query that will sort through the fields and use the mailing
address if one is entered and if not use the regular address.
Any suggestions and help would be appreciated.

Thanks

Amy
Click to expand...

Amy,
If you want to do this in a query,
add a new column to the query qrid.
MailItTo: IIf(IsNull([MailAddress]),[RegularAddress],[MailAddress])

Use the [MailItTo] field in the report as the address field.
 
I guess I am just not getting it. Maybe there is a problem with my query.
What is the easiest way to accomplish this.
All I want is to be able to run a report that will print mailing labels and use their mailing address if it is different from the main one entered.
Thanks for your help
I will keep plugging away at it
 
Back
Top