too many fields defined
in [Queries]
|
From: Jeff Kaufman on 12 Feb 2010 09:21 I am getting a too many fields defined error when attempting to add 5 different queries into 1... what is happening?
From: Allen Browne on 12 Feb 2010 10:59 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.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jeff Kaufman" <JeffKaufman(a)discussions.microsoft.com> wrote in message news:09B02B8B-A131-4D1A-A6E9-BB91CEC54877(a)microsoft.com... > I am getting a too many fields defined error when attempting to add 5 > different queries into 1... what is happening?
From: Jerry Whittle on 12 Feb 2010 11:05 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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Jeff Kaufman" wrote: > I am getting a too many fields defined error when attempting to add 5 > different queries into 1... what is happening?
|
Pages: 1 Prev: Multiple Commas Next: Display multiple pivot charts in several pages |