|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 3rd, 2008, 09:43 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Crosstab Query
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. 
|
|
#2
July 3rd, 2008, 11:08 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Query
If I assume your data is properly normalised create a totals query using the date as a grouping column? No need for a crosstab. "acccessaccess2003" wrote: 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.
|
|
#3
July 3rd, 2008, 02:49 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Query
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 "acccessaccess2003" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
