I have a crosstab query (qryRollAvg)that I need to modify the ColumnHeading property to equal strHeader (actaully the value of variable strHeader) using ADO. Any help would be greatly appreciated.

Tom

You can change the Column Headings to what every you want in the PIVOT part of the SQL statement. However, whatever have in Column Headings is what the query looks for when returning the data. If the headings you enter do not match the values in the PIVOT column the query will not return anything. Changing the column headings really only serves to reorder the results or limit what is returned by the query.

In any case, here is the syntax of the PIVOT part of a CrossTab with the Headings entered

PIVOT tblCrossTabTest.MonthYear In ("Jan-2000","Feb-2000","Mar-2000")

Hope this is clear. It is kind of hard to explain.





Doogie's Mom
Look at the World with the Eyes of a Child