crosstab union???

  • Thread starter Thread starter Guest
  • Start date Start date
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 provided a fairly comprehensive reply. The primary importance is
entering all the Column Headings.

I hate to ask but why do you think you need to create a union query of a
couple crosstabs? You might be able to create a union query and then a
crosstab off the union query.
 
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.
 
I hate to ask but why do you think you need to create a union query of a
couple crosstabs? You might be able to create a union query and then a
crosstab off the union query.
Click to expand...

LOL, I'm thinking back (couple of years) to when I "had to" union 2
crosstabs and I am thinking that maybe I could have done it the other way
around & saved a lot of teeth-knashing.

Hindsight is such fun! :-)
 
Back
Top