union crosstab query

[inungh]

I tried to union 2 crosstab queries with same fields output, but
Access complained syntax error.


I just wonder does Access support union crosstab queries?
If not, are there any workaround?


Your information is great appreciated,

 

[KARL DEWEY]

Why not union then crosstab?
Post your SQL.

 

[John Spencer]

I think it might *** I F *** you declare the columns of the crosstab and they
match. Use the Column Headings property if you are in design view. In SQL
view you would have a line that read something like the following.

PIVOT FAQ.fKeywords In ("x","y");

Replace X and Y with the names of the columns that are returned.


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County