Addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Bell - 24 Dec 2005 04:05 GMT

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

Reply to this Message

Duane Hookom - 24 Dec 2005 04:15 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 6 lines]
> label report to reflect this?
> Thanks for any help

Reply to this Message

Frederick Wilson - 24 Dec 2005 13:47 GMT

> You can set a control source to:
> =Nz([POBox], [ResidentialAddress])
> The ResidentialAddress will show only if POBox is null.

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,

Signature

Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com

Reply to this Message

Duane Hookom - 24 Dec 2005 15:55 GMT

I would leave these two tables in the same table.

Signature

Duane Hookom
MS Access MVP
--

>> You can set a control source to:
>> =Nz([POBox], [ResidentialAddress])
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message