Crosstab Columms

S

Squidly

I get "Too many crosstab columm headers (###)" when I run this query and
there is more than 255 records to report on.
How can I increase the number of headers this query will report on.

Thanks for any help.

Syd Taylor
 
R

Rick Brandt

Squidly said:
I get "Too many crosstab columm headers (###)" when I run this query
and there is more than 255 records to report on.
How can I increase the number of headers this query will report on.

Thanks for any help.

Syd Taylor
Click to expand...

You cannot. 255 is a hard limit on field count in both queries and tables in
Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

<ASK> How to add columm more than the default columm IV 3
Section and Page numbering 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Multiple templates with common styles 2
Incone & Expenses Statement 0
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Macro to compress logo (image) 1
What is the formula for adding up *values! in a columm in exell 1

Top