crosstab query and asp
Do you know if ASP supports crosstab queries? I created following query;
strMonth = "TRANSFORM Count([PrimaryKey]) AS CountOfPrimaryKey SELECT (Format([Received Date],'MMM')) AS sMonth FROM [2005 Received Records] GROUP BY (Year([Received Date])*12+Month([Received Date])-1), (Format([Received Date],'MMM')) PIVOT [SubLate]"
It perfectly works in MS Access, however I always get empty recordset when I run it in ASP page.
Any help would be appreciated...