Cross Tab Web Report in Access 2010

[lodhi1978]

Hi All,

I want to create a cross tab web report in Access 2010,

The query is below

TRANSFORM Count(AssetsExtended.Item) AS CountOfItem
SELECT Year([RetiredDate]) AS [Year]
FROM AssetsExtended
WHERE (((AssetsExtended.RetiredDate) Is Not Null))
GROUP BY Year([RetiredDate])
ORDER BY Year([RetiredDate])
PIVOT Month([RetiredDate]);

Thanks,