J Jeff Kaufman Feb 12, 2010 #1 I am getting a too many fields defined error when attempting to add 5 different queries into 1... what is happening?
I am getting a too many fields defined error when attempting to add 5 different queries into 1... what is happening?
A Allen Browne Feb 12, 2010 #2 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.)
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 Feb 12, 2010 #3 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.
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.
