error message:"Too many crosstab column headers (226)"

[afshin]

In source data of my chart, because that data is more, access informed to me that
"Too many crosstab column headers (226)"


Have any way to resolve this?

[CJ_London]

only by having two or more crosstabs and then linking them on suitable fields. But note there is a maximum number of columns of 255 for a query anyway so it won't get you much further.

If you go this route, if you end up with differing numbers of rows due to there being records in one crosstab and not the other (and visa versa) the standard solution is to have a third query which lists all the possible rows (e.g. all customers) which is then left joined to the crosstabs

[CJ_London]

just noticed the error says 266 columns, you have stated 226 - so suspect there is not a solution as such resulting in a single query. Google 'Access maximum values' to find out what the limits are.

You might want to re-examine the business needs to see if you can limit the number of columns in some way