Mailing labels

  • Thread starter Thread starter Peggy
  • Start date Start date
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.
 
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])
 
Back
Top