Too many crosstab column headers (454)

[Gkirkup]

I am attempting to create my first crosstab query in design view. Adding a simple row and column header and one value, I always get the error message 'Too many crosstab column headers (454)'. What am I doing wrong? Here is the SQL:

TRANSFORM Sum(Forecast.QTY) AS SumOfQTY
SELECT Forecast.HECI
FROM Forecast
GROUP BY Forecast.HECI
PIVOT Forecast.QTY;

Robert

 

[Grave]

I am attempting to create my first crosstab query in design view. Adding a simple row and column header and one value, I always get the error message 'Too many crosstab column headers (454)'. What am I doing wrong? Here is the SQL:

TRANSFORM Sum(Forecast.QTY) AS SumOfQTY
SELECT Forecast.HECI
FROM Forecast
GROUP BY Forecast.HECI
PIVOT Forecast.QTY;

Robert

You tried to make 454 columns but you only can make 255 columns... I think.

 

[Gkirkup]

Grave: Where did I make 454 columns? I tried to make just one column - QTY. How do I correct that?

Robert

 

[Grave]

Grave: Where did I make 454 columns? I tried to make just one column - QTY. How do I correct that?

Robert

I think...

I'm not very good in this either. I just know i had this once when i tried to transform... And that number behind the error was exact the same as the numbers of columns i tried to make. max number of columns is 255 i think.

 

[KernelK]

A crosstab query will have as many columns as there are unique values for the field you choose to become the column headers. Thus, you did not try to create just one column for QTY, you created a column for each value of QTY. Do a count of your unique QTY values and see what you get.