N
NFL
I have a query that worked fine for a while until now. Error #:3205 Too many
crosstab column headers (300). How can I fix this error? Thank you!
TRANSFORM Count(MainTable.CSENO) AS CountOfCSENO
SELECT MainTable.DocketDate, MainTable.Type, Count(MainTable.CSENO) AS
[Total Of CSENO]
FROM MainTable
WHERE (((MainTable.DocketDate) Between
DateSerial(Year(Date()),Month(Date()),1) And
DateSerial(Year(Date()),Month(Date())+1,0)))
GROUP BY MainTable.DocketDate, MainTable.Type
PIVOT MainTable.Autonumber;
crosstab column headers (300). How can I fix this error? Thank you!
TRANSFORM Count(MainTable.CSENO) AS CountOfCSENO
SELECT MainTable.DocketDate, MainTable.Type, Count(MainTable.CSENO) AS
[Total Of CSENO]
FROM MainTable
WHERE (((MainTable.DocketDate) Between
DateSerial(Year(Date()),Month(Date()),1) And
DateSerial(Year(Date()),Month(Date())+1,0)))
GROUP BY MainTable.DocketDate, MainTable.Type
PIVOT MainTable.Autonumber;