Mailing labels


P

Peggy

I would like to print labels from a table. My table
has "Service Address" and "Billing Address" Some customers
have both addresses and some have only a service address.
What I want it to do is if there is a billing address
print that else print the service address.
I'm a newbie so this has to be simple.
 
Ad

Advertisements

F

Fredg

Peggy,
The simplest way would be to use a calculated control instead of the
actual control.
So, in the label report, instead of one control for [Service Address]
and one for [Billing Address], replace them with a single control.
Set it's control source to:
= IIf(IsNull([Billing Address]),[Service Address],[Billing Address])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mailing labels 1
Mailing Label 1
mailing labels 1
Mailing Labels 3
mailing labels 0
mailing labels 1
Mailing Labels 1
Mailing Labels 1

Top