Is TRANSFORM clause supported by VB?

[ormus]

Is the 'TRANSFORM' clause in MS ACCESS's crosstab query recognised by VB?

I have a crosstab query that looks like the following:

TRANSFORM First(Table2.E) AS FirstOfparam
SELECT Table2.A, Table2.B, Table2.C,
FROM Table2
GROUP BY Table2.A, Table2.B, Table2.C
PIVOT Table2.D;

VB doesn't seem to like the TRANSFORM construct!

 

[sfreeman]

Check it out:

http://databasejournal.com/features/msaccess/article.php/10895_3101941_4

Sam_F
"90% of the problem is asking the right question.

 

[VBslammer]

Creating a cross-tab using standard SQL is quite a chore if you have many values to calculate. Transform is a perk of Access, and most client-server systems rely on stored procedures to build the cross-tabs using temp tables.

Excel is often used via automation to create cross-tab data.

Here's a good article that explains the basics of building a cross-tab using SQL:

Generating Database Server-Side Cross Tabulations

VBSlammer

"You just have to know which screws to turn." - Professor Bob