mailing list..

[keybearer]

Hi.. i need a bit of help here.. i'm currently doing a contacts mailing list.. in the database, there are office address and home address.. a contact can choose either addresses as their mailing address..

i want the mailling list to display something like this..

[member ID]
[Title] [Name]
[address]
[postcode][state]

since the addresses differ in their format, i.e the office address has another line below the name..

[member ID]
[Title] [Name]
[organization]
[address]
[postcode][state]

i can do this by following the example in the northwind db but i have to create 2 different reports. how do i display the addresses without creating 2 different reports?

 

[Rich]

Provided you have the controls can shrink property set to yes it shouldn't matter that organisation might not have associated records, however I prefer a single text box with something like
=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & IIf(IsNull([City]),"",[City] & Chr(13) & Chr(10)) & [PostalCode] as its control source