Print preferred address when contact has multiple addresses.

[R. Soto]

I want to create mailing labels that will print the preferred address for a
contact. I think the query should follow the logic -- If preferred address is
home, then print home address fields. If preferred address is business, then
print business address fields. Currently I have two separate queries and two
separate mailing lable reports ... one for home the second for business. I'm
certain this con be accomplished with one query and one mailing label report!

Any help you can offer is greatly appreciated!

 

[[MVP] S.Clark]

I would continue using multiple queries, just write the result to one
destination table. Then use that table as the basis for the label report.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Van T. Dinh]

You can use a calculated Field with IIf() function in the Query being used
as the RecordSource for your Labels. Something like:

MailingAddress: IIf( [HomePreferred] = True, [HomeAddress], [BussAddress] )