Access Crosstab query to SQL Query string

[meldrape]

Hello,

I've created this crosstab query in Access and it works great but my back end is SQL2000. How can this be rewritten to pull from a SQL2000 database in an ASP? Thank you very much in advance.

TRANSFORM Sum(qyMatrixTest.numitems) AS SumOfnumitems
SELECT qyMatrixTest.cname
FROM qyMatrixTest
WHERE (((qyMatrixTest.ocustomerid)=271))
GROUP BY qyMatrixTest.cname, qyMatrixTest.ocustomerid
PIVOT qyMatrixTest.orderid;

 

[vbkris]

the query doesnt run directl in SQL2000?

Known is handfull, Unknown is worldfull

 

[meldrape]

No it doesn't. SQL2000 doesn't support TRANSFORM. Thanks for your response!

 

[vbkris]

i myself dont know what transform does, can u give me an idea, i amy be able to suggest an alternate query...

Known is handfull, Unknown is worldfull

 

[meldrape]

Thanks again for your reply. I actually found something on this forum, thread333-686822. Somebody had a similar situation and somebody else had a great answer. Once again, thanks for trying to help.