Union Crosstab

[dssrun]

I have read some threads on how to union multiple crosstab tables, but it is giving me an error, saying "Missing operator" on the first cross tab query last line where my query says "Pivot...UNION ALL...(SQL of next crosstab)". I checked both crosstabs independently and they work. I need it run like this for a report. Both queries have the same columns. Any help will be appreciated

PARAMETERS xxxx DATETIME
CROSSTAB QUERY

UNION ALL

CROSSTAB QUERY

[TheShabz]

There's probably a less kludgy way around it but what I do is save my crosstab queries in another query. and then do a union on those queries.

So let's say you have qryCrosstab1 and qryCrosstab2 which are crosstab queries. I'd create 2 more queries qryVwCrosstab1 and qryVwCrosstab2 which are essentially "SELECT * FROM qryCrosstab1" and then do a union on the Vw queries:

SELECT * FROM qryVwCrosstab1
UNION
SELECT * FROM qryVw Crosstab2

[dssrun]

Thanks for the idea. What I actually did was reverse my logic, I did all unions then crosstab the unions.