Cross Tab Query, limit to # of Row Headings ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Does anyone know if their is a limit of how amny fields (Row Headings)
there can be in a Cross Tab Query ?

I have one where there are around 65 & when I run it the data is not coming
out right but if I get rid of a few fields then the data is ok.

Any help would be greatly appreciated.

Thank you,
Jeff
 
I thought there was a limit to the number of fields allowed in a group by
but I don't see it in the Access Specifications in help. Apparently it might
be 64 but I thought it was much lower.
 
There is a 255 column limit on any query.
There is also (not counting memo fields) a 2000 character limit per row.

So, if you have five columns that are not in the pivot then you could in theory
have 250 columns in the pivot.
 
Hello John, Thank you.

is that 2000 limit for a single Field, or for all Fields combined ?

If combined does that mean if text field is set to 255 characters thats you
cant have more than 7 of them ? I am a little confused, can you shed more
light ? Have any links to articles about this ?

Thank you,
Jeff
 
The limit would be 2000 characters per row/record. This is actual displayed
characters.
So, if you have 65 row headings and derive 20 column headings and the
average number of characters is 24, you have pushed beyond the limit.
 
Hi Duane,

Thank you. But what if I have this Cross Tab Query as the Record Source for
a Sub Form, would that still apply ? or is that limit just in a Query view ?

Thank you,
Jeff
 
The limit still applies. The record source is a table or a query. SO
255 Columns Maximum
2000 Characters Maximum
(Memo fields and OLE objects take 8? bytes each - if I recall correctly)
 
Back
Top