Display Crosstab Query Results - HELP?
Is it possible to display the rusults of a crosstab query in an asp page???
Ive written the followign script but keep getting an error:
strSQL = "TRANSFORM Count([OP MORR MDS].InternalPatientNumber) AS CountOfInternalPatientNumber SELECT [OP MORR MDS].consfull FROM [OP MORR MDS] GROUP BY [OP MORR MDS].consfull PIVOT [OP MORR MDS].[NEW STATUS] In (""ATT NEW"",""ATT FOLLOW UP"","DNA NEW","DNA FOLLOW UP")";
My connection is working properly.
Many thanks for your help.