Combine all info

[Confused87]

I have two tables with address data in them - they have nothing in common,
except needing to go on the same list (a mail out). How do I combine this
data so I have a list for labels to be printed(using a report)?

As they have nothing in common except a tick box I am not sure how to do
this in a query - any ideas?

Thanks

 

[John Spencer]

You will need to use a UNION query. The queries that are the components
of a UNION query must have the same number and types of fields and the
fields must align with each other. UNION queries can only be created in
the SQL view; however, you can create one query against each of the
tables - making sure your select lists parallel each other.

Once you have two saved queries, you can open a third query as a UNION
query and reference the two saved queries. The SQL statement for the
UNION query might look like the following

SELECT * FROM [QueryAddressTableA]
UNION
SELECT * FROM [QueryAddressTableB]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================