S scubadiver Jun 6, 2008 #2 I don't know to be honest. Provide more info about what you want to achieve.
J John Spencer Jun 6, 2008 #3 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
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
D Duane Hookom Jun 7, 2008 #4 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.
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.
