Address

[Roger Bell]

I have designed a Data Bases which has, specifically, two seperate fields:
Residential Address
Postal Address for PO Boxes as separate from Residential where they exist

What I would like, when printing labels and envelopes, is for the system to
pick up the Postal Address, if it is not null, otherwise, display the
Residential address. Could I use the IIf function, built into the label
format which exists as follows:
=Trim([title for pg] & " " & [lname]) & Chr(13) & Chr(10) & Trim([unit/flat]
& " " & [unit/flat no] & " " & ([street number] & "" & [street prefix] & " "
& [street name]) & Chr(13) & Chr(10) & Trim([suburb] & " " & [state] & " "
& [pcode]))

Thanks for any help

 

[tina]

do you have a separate table for addresses, since your client (customer,
patient, subscriber, whatever) may have more than one address? if not, you
should. if you do, you might add a field to the addresses table, as

ResidenceOnly (Yes/No data type)

for those addresses which are residence only, not mail/residence, the
ResidenceOnly field will be True. then you can write a query for the Labels
report, linking the client table to the child addresses table, and returning
only those records where ResidenceOnly = False.

hth