If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Address
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 |
#2
|
|||
|
|||
Address
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 "Roger Bell" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|