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

Too Many Fields Defined 2
"Fields Nested Too Deeply" Error in Simple Word Document 5
You don't currently have permission to access this folder 0
Access error 3059 0
Outlook 365 Signatures 0
Creating a Search using a combo box and then creating a report. 4
Relating 2 separate texts in word 1
Total Number of fields in a query 4

Top