Catalonia is Not Spain

Archive for the ‘SQL’ Category

Access SQL TRANSFORM Statement

Posted by putxi on March 16, 2007

The Access SQL TRANSFORM statement is a non-standard extension to SQL-92 implemented by Microsoft’s JET database engine to create crosstab queries. Crosstab queries calculate a sum, average, count, or some other aggregate on rows, and then group the results in two dimensions: one down the left side (row headings) and the other across the top (column headings). In Excel these are called PivotTables. In SQL Server you’re on your own.Crosstab queries provide a powerful data analysis tool, but can be tricky to use in Access. It’s not that they’re hard to create. Access provides a wizard for creating new ones, and the syntax is pretty straightforward, if under-documented (that TRANSFORM link above is to the Access 97 documentation). It’s using them, like as the basis for a report, that can be tricky. Read the rest of this entry »


Posted in SQL | 3 Comments »