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! :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query is too complex 5
union crosstab query 2
Union Query Based on Two Crosstab Queries 4
Date Limit in Crosstab from Union query 2
Union Query with two crosstabs 2
A Complicated Query Question 4
crosstab query? 3
crosstab query questions 6

Back
Top