Mailing List Query

[razjafry]

Hi Experts,
I have two tables - tblContact and tblOrg
Contact table has only one option of mailing address e.g address,city,postal code
whereas Org table has two options - one simple address - address,city, postal code
and other one is mailing address which is populated automatically if a check box is checked "Is mailing address same" - mailing address, mailing city, mailing Postal code
I want to generate a mailing list that gets all the addresss of the Contact table and
all the addresses from Org table but with mailing address populated as the first choice and if mailing address is empty then to use the simple address.
I really appreciate any help.
Regards,
Raz

[n8kindt]

have u tried using the Nz() function? if you are populating the list using a query, a simple example would be this:

MailingListAddress: Nz(MailingAddress, SimpleAddress)

MailingAddress is selected unless it is Null... in which case, SimpleAddress would be selected

[razjafry]

Thanks a lot n8kindt
Nz() is a good one that I didn't know about.
I got my problem solved partially though as two tables are related and any entry in the Org table that doesn't have a contact associated with it from Contact table is not shown in the result set.
How I can have all the records from both table?
I am using MS Access 2000 and tblOrg is master table in the relationship.
Thanks for the help.
Raz

[n8kindt]

Thanks a lot n8kindt
Nz() is a good one that I didn't know about.
I got my problem solved partially though as two tables are related and any entry in the Org table that doesn't have a contact associated with it from Contact table is not shown in the result set.
How I can have all the records from both table?
I am using MS Access 2000 and tblOrg is master table in the relationship.
Thanks for the help.
Raz

have u looked into union queries? i think that might be what u need.