Mailing labels

[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.

 

[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])