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.
 
Top