Crosstab column header limit in 2010

[cl8390]

Hi All-

I've searched the web but surprisingly can't come up with an answer for this simple question:

Does Access 2010 have a limit on the number of column headers in crosstab queries? If so, what is it? I know that Access 2007 is limited to 255. I need to run multiple crosstabs with ~700 headers (and 40k rows, so transposing the table is not an option) and need to know if it'd be worth it to upgrade to '10.

Thank you!

 

[SydneyGeek]

700 columns? Are they individual dates?

I'm pretty sure that the standard size limits (255 fields, 2GB overall size) have not changed in 2010.

Denis

 

[Russell Hauf]

There are better ways to do what you need than a 700 column crosstab.