Upsize Jet Crosstab Queries

by Roger Jennings - Crosstab queries have been a primary selling point for Access since Microsoft released version 1.0 in 1993. A multitude of Visual Basic developers depend on Access' Crosstab Query Wizard to create persistent QueryDef objects or as a helper for generating Jet crosstab SQL statements with code. Access' Chart Wizard generates a crosstab query as the data source for charts and graphs. Despite the popularity of Jet crosstabs, the SQL Server team implemented the non-ANSI and seldom-used ROLLUP and CUBE operators, but not PIVOT and TRANSFORM—both are necessary for generating crosstabs.

Read More >>