too many fields defined

J

Jeff Kaufman

I am getting a too many fields defined error when attempting to add 5
different queries into 1... what is happening?
 
A

Allen Browne

No table or query can output more than 255 fields.

Also, all the data in any record has to fit into the page buffer (4kb in
current versions.)
 
J

Jerry Whittle

I believe that 255 fields is the maximum.

Post the SQL for the 5 queries and the final query where you are attempting
to combine them.
 

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

Total Number of fields in a query 4
Too many fields defined in select query 4
export crosstab query too many fields defined 4
Too many fields defined 1
type conversion failure in append query 3
Too Many Fields Defined in Query 11
Too Many Fields Defined Error 1
Bytes Per Row 1

Top