Results 1 to 3 of 3

Crosstab column header limit in 2010

This is a discussion on Crosstab column header limit in 2010 within the Microsoft Access forums, part of the Question Forums category; Hi All- I've searched the web but surprisingly can't come up with an answer for this simple question: Does Access ...

  1. #1
    New Member
    Join Date
    Feb 2013
    Posts
    1

    Question Crosstab column header limit in 2010

    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!

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,213

    Default Re: Crosstab column header limit in 2010

    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
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Beaverton, OR USA
    Posts
    1,457

    Default Re: Crosstab column header limit in 2010

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

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com