Crosstab query for multiple columns hierarchy

[ysrini]

Hi, i have list of Employees who earn points for ProjA and ProjB for every month.
Using Pivot Table View i can see Employees with columns divided by Months
and this column further sub divided by ProjA and ProjB.
I cannot use this pivot table on the report form, so i tried creating a Crosstab query

However, i can't specify to show columns first grouped by Month and then by Proj A and B

If i choose only for ProjA, the sql is:


TRANSFORM First(Emp.ProjA) AS FirstOfProjA
SELECT Emp.ID
FROM Emp
GROUP BY Emp.ID
PIVOT Emp.Month;

The attached screenshot shows the Pivot Table View at the top and the CrossTab Query at the bottom. The crosstab query should be fixed to look like the table at the top
The months are designated by numbers

How can i show columns grouped by Month and then show for both Projects A&b?

Thanks
-srinivas

[jbarrum]

I think you will benefit from this article: http://allenbrowne.com/ser-67.html