Maximum Number of Crosstab Column Headings

  • Thread starter Thread starter Cydney
  • Start date Start date
C

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
 
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
 
Back
Top