Re: crosstab union???

Tech-Archive recommends: Fix windows errors by optimizing your registry

I think I can accomplish my goal it may require a couple IFF statements in
the UNION before the crosstab. Thanks for the help!! I was mainly courious
to see if it could be done.

"George Nicholson" wrote:

> 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: forgot code....cross tab column sum
    ... "Duane Hookom" wrote: ... each crosstab separately and then use something like: ... and code below UNION ALL works ... GROUP BY "Detail", EmployeeName ...
    (microsoft.public.access.queries)
  • Re: crosstab union???
    ... but remember that Union queries require that all queries they are ... As long as you can control your crosstab ... > Is it possible to UNION 2 crosstab queries together? ...
    (microsoft.public.access.queries)
  • RE: You can get a total column in a crosstab query
    ... Totals in last row of crosstab query is possible using a union ahead of the ... The union to have a select query with added 'Sort' field with "0". ...
    (microsoft.public.access.queries)
  • Re: cross tab column sum
    ... You can't in a query unless you use a union query. ... based on another crosstab that didn't group by employees? ... The Union SQL might look something like the following. ... GROUP BY "Detail", EmployeeName ...
    (microsoft.public.access.queries)