Crosstab Query

  • Thread starter acccessaccess2003
  • Start date
A

acccessaccess2003

I have a crosstab query created and generates the following result set.
[ID] [2008 04] [2008 05]
1 5 4
2 4 2
3 3 0

Is there any way that I can crosstab to obtain the following table?

[Month] [Total]
[2008 04] [12]
[2008 05] [6]

Any help is very much appreciated.
 
S

scubadiver

If I assume your data is properly normalised create a totals query using the
date as a grouping column? No need for a crosstab.
 
M

Michel Walsh

Jet does not have CUBE (neither ROLLUP), and even if we can simulate them,
here, the easiest way seem to make two crosstabs, one with GROUP BY id, and
one with GROUP BY null (or group by on any constant) , and then, UNION ALL
the two crosstabs in third query.

Vanderghast, Access MVP
 
Top