Address

R

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address Envelope with Trim 1
Mailing address 1
Mailing Address 5
Mailing Address 3
Labels 4
Sorting a concatenated query problem 7
Replace commas with hard return in a query field 2
Text Box in a Report 1

Top