Union Query three tables

[Guest]

I am a novice to Access and I'm sure this is a easy to do, but I am having a
problem combining three tables. I figured out how to combine two tables using
a Union Query, but can I also combine the other table in the same query? I
keep getting an error message when I try.

 

[David Lloyd]

You can union more than two tables in the same query.

You may want to post the error message you are receiving.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am a novice to Access and I'm sure this is a easy to do, but I am having a
problem combining three tables. I figured out how to combine two tables
using
a Union Query, but can I also combine the other table in the same query? I
keep getting an error message when I try.

 

[John Vinson]

I am a novice to Access and I'm sure this is a easy to do, but I am having a
problem combining three tables. I figured out how to combine two tables using
a Union Query, but can I also combine the other table in the same query? I
keep getting an error message when I try.

SELECT this, that, theother FROM Table1
UNION < or UNION ALL >
SELECT what, who, which FROM Table2
UNION
SELECT first, second, third FROM Table3;

All of the SELECT clauses must have the same number of fields, and
they must match in size and datatype.

If you have a query - it helps to post the SQL.
If you have an error message - it helps a LOT if you post the error.

You can see your computer; we cannot!


John W. Vinson[MVP]