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...

access

arnel_gp
Sep 13, 2022
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.

arnel_gp

Iron Contributor

Sep 13, 2022

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.

Tony2021
Iron Contributor
Sep 14, 2022
Thank you Arnel and Karl. Your strategy worked!

Forum Discussion

Join 2 Crosstabs using a UNION (Syntax)

Resources