Maximum Number of Crosstab Column Headings

[Cydney]

What is the maximum number of crosstab column headings I am allowed in my
query? I need about 200 columns.
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson

 

[John Spencer]

Maximum number of fields in a query is 255. So unless you have more that 50
or so columns that are not generated by the pivot statement you should have no
problem.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

I believe the total is the same as the number of columns in a table (255).