Append but no table?

[Andy]

I have multiple tables and wish to write a query to 'append' them together. I
have a common customer number against each record in each table.

For customer I want to run a select query that will generate a row for the
customer number from each table without having to write tables, and append
customer records from each table to this table.

 

[John Spencer]

Take a look at UNION queries. UNION queries can only be created in SQL view.
Generically, a union query for three tables would look something like the
following.

SELECT CustomerID, CustomerName
FROM Table1
UNION ALL
SELECT Customer_ID, CustomersName
FROM Table2
UNION ALL
SELECT CustID,CustName
FROM Table3

You must have the same number fields in each of the query clauses and the
fields must align as to type (text, number, date, etc). Read the help on
UNION queries for more information.

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

 

[Tom van Stiphout]

On Fri, 31 Jul 2009 03:59:01 -0700, Andy

If I understand you correctly the first query would be a MakeTable
query, the others would be Append queries.

-Tom.
Microsoft Access MVP