PIVOT query - access to mssql - help wanted!

[barretldw]

Hi, i'm trying to convert the following query:

TRANSFORM Sum(tblAssortim ent.Aantal) AS SumOfAantal
SELECT tblAssortiment. Assortiment
FROM tblAssortiment
WHERE (((tblAssortime nt.Artikel)=?))
GROUP BY tblAssortiment. Assortiment
PIVOT tblAssortiment. Maat;

Any ideas how to do this?

Thank you!