Hello everyone,

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...

Thanks.