Forum Discussion
Solved
Join 2 Crosstabs using a UNION (Syntax)
Experts, I am trying to join 2 queries into a Union. I am getting a syntax in the following: Do you see where I am wrong? The queries work separately. thank you very much. here is m...
you can try this.
save Each Crosstab in its own Query.
then Select them to create a Union Query:
Select * From CrosstabQuery1
UNION
Select * From CrosstabQuery2;
Note that both query should have exactly The Same Number of Columns.
Hi,
Maybe it just doesn't work out of timing/processing reasons because of the "dynamic" character of the crosstab SQL. Try to save the two queries and use e.g.
SELECT * FROM Query1
UNION ALL
SELECT * FROM Query2
or a bit shorter
TABLE Query1
UNION ALL
TABLE Query2
Servus
Karl
Access News
Access DevCon