Re: crosstab union???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes, but remember that Union queries require that all queries they are
joining have the same # of fields. As long as you can control your crosstab
output with either a *very* static set of values (Jan - Dec) and/or using
the cross tabs "Column Headings" property (Mark, Tom, Sara, Other, etc.),
you can combine them in a separate Union query.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"anthonysjo" <anthonysjo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52044C3C-E2F4-4B54-959C-61AA85B80BA6@xxxxxxxxxxxxxxxx
> Is it possible to UNION 2 crosstab queries together?


.

Relevant Pages

  • Re: Make-table (?Materialized views?) of complicated cross tabs, calculated field
    ... be able to run fairly sophisticated queries in Access. ... The problem is I'm compiling about 10 fields of "1-5" rank responses ... I do the crosstab on that Union. ...
    (comp.databases.ms-access)
  • Re: crosstab union???
    ... the UNION before the crosstab. ... "George Nicholson" wrote: ... but remember that Union queries require that all queries they are ... As long as you can control your crosstab ...
    (microsoft.public.access.queries)
  • Re: Query is too complex
    ... And if your table have one field for each compound, ... of queries to populate it as needed. ... to use the Union queries that are working now. ... I also developed the union query to union together those 2 queries. ...
    (microsoft.public.access.queries)
  • Re: Combining records from two queries
    ... combining UNION and SELECT queries to best effect. ... Using my query names, can you say exactly what my SQL should be ... > my Union Queries short and simple and do the rest of the work elsewhere. ... >>> Subject and Professional Mentors that are allocated to placements. ...
    (microsoft.public.access.queries)
  • Re: Question about Queries with Subqueries
    ... performance reasons to use UNION ALL instead of UNION. ... i have a query i am working on that draws data from 3 different data ... i have a question about queries like this. ... to try "flattening" my queries by using subqueries. ...
    (microsoft.public.access.queries)