Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    159

    Unanswered: crosstab query error

    A cross tab query I have been using to total purchases by adding up the individual quantities in a single invoice and then summing all the invoices has stopped running with the error that there are two many crosstab fields(254) .
    Now I can see that there might be a limit of 254 set somewhere for the number of fields but how do I make that larger? Or is this a limit set in Access? In that case I will have to rewrite the queries which I don't want to have hanging over me on a Friday morning.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    slightly suprised by your 254 field limit: i thought that A's limit was 255 fields in a query.

    ...assuming that one more field is not going to make your day - it's a rewrite for you.

    happy weekend

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    May 2004
    Posts
    159
    actually the error said 254 collums was all it could handle so with the referenced field added that would make 255 fields.
    Well I was able to rewrite the all queries in just under 2 hours so I get to go home early today after all. Lesson learned about the crosstab!

Posting Permissions

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