Hi…I attempted to do a Union Query with two crosstabs. I received an error
“Characters found after end of SQL statement. I then read some posts but
couldn’t find the solution. It appears that it is possible and I read
something about not having two TRANSFORM statements but it wasn’t clear to
me. I have the same number of fields and defined the PIVOT part by IN(“x”,
“y”, “z”) and used UNION ALL. What else do I need to do to join the two
crosstabs?

Thanks for any suggestions.