crosstab querys

[Stacy]

How do you query two sperate cross tab querys to make one query?

 

[scubadiver]

I don't know to be honest. Provide more info about what you want to achieve.

 

[John Spencer]

Do you want to combine the crosstabs vertically (a union query) or
horizontally (a join of some type)?

For example.
Crosstab A returns these columns
A x1 x2 x3
Crosstab B returns these columns
A b1 b2 b3 b4

Do you want to end up with the following?
A x1 x2 x3 null
A b1 b2 b3 b4

Or do you want to end up with the following?
A x1 x2 x3 b1 b2 b3 b4

If you want the first option, you are going to have to specify the columns
returned by the crosstabs in order to use a union query.

If you want the second option, you may have to specify the columns returned
depending on which column(s) you are going to use in the join.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Duane Hookom]

You haven't provided much to go on but if you want, you can create a crosstab
with multiple values as described at
http://www.tek-tips.com/faqs.cfm?fid=4524.