column header error in crosstab query

[TLJ]

My cross tab column have exceeded 250. Last month my crosstab worked fine with 244, now with 272 headings it will not. Is this an access limit or can I change. I am using a crosstab query to count as well as identify males and females and two other categories. Any help appreciated.

 

[Ian Mac]

My cross tab column have exceeded 250. Last month my crosstab worked fine with 244, now with 272 headings it will not. Is this an access limit or can I change. I am using a crosstab query to count as well as identify males and females and two other categories. Any help appreciated.

The limit is 256 and can not be changed.

That a lot of columns? do you need that many?

I'm assuming it's for visual purposes, can you not break it down to more managable chunks months, area etc.