Addresses

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

Guest

I have designed a data base that has amongst others a field for residential
address and a field for postal address. The postal address field is only
used when it is a Post office Box. The problem is that when I send out mail,
I want the system to be able to use the postal address for box Nos. and the
residential address for the others. Is there a way I can design the mailing
label report to reflect this?
Thanks for any help
 
You can set a control source to:
=Nz([POBox], [ResidentialAddress])
The ResidentialAddress will show only if POBox is null.
 
Duane said:
You can set a control source to:
=Nz([POBox], [ResidentialAddress])
The ResidentialAddress will show only if POBox is null.
Click to expand...

A bit unrelated, but isn't it bad form to have several nulls in a table.
So for the example here, instead of having the PO address in the same
table as the residential address they would be in different tables to
avoid the null?

Thanks,

--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
 
I would leave these two tables in the same table.

--
Duane Hookom
MS Access MVP
--

Frederick Wilson said:
Duane said:
You can set a control source to:
=Nz([POBox], [ResidentialAddress])
The ResidentialAddress will show only if POBox is null.
Click to expand...

A bit unrelated, but isn't it bad form to have several nulls in a table.
So for the example here, instead of having the PO address in the same
table as the residential address they would be in different tables to
avoid the null?

Thanks,

--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
Click to expand...
 
Back
Top