union crosstab query

  • Thread starter Thread starter inungh
  • Start date Start date
I

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,
 
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
 
Back
Top