Hi,

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.

Tim



Tim

__________________
Tim