AppendQuery Error Paul B 11/11/2008 8:46:16 PM Setting up an AppendQuery. When I click RUN I get an error message that says" INSERTINTO contains unknown 'Field25". Checking the SQL code it does not have 'Field25". INSERTINTO contains only the fields that I put in. ???????????? -- Paul B

Re: AppendQuery Error "Pete D." <pduffy211AT[ at ]coxDOT.net> 11/11/2008 10:24:04 PM Try changing to SQL view and see if you can now see it. Sometimes in the query design grid something get put in by accident and you can scroll around for an hour and miss the box it got put in. "Paul B" <PaulB[ at ]discussions.microsoft.com> wrote in message news:7854429B-E1C2-4EEB-821C-285E10A8F10D[ at ]microsoft.com... [Quoted Text] > Setting up an AppendQuery. When I click RUN I get an error message that > says" INSERTINTO contains unknown 'Field25". Checking the SQL code it > does > not have 'Field25". INSERTINTO contains only the fields that I put in. > ???????????? > -- > Paul B

RE: AppendQuery Error Clifford Bass 11/11/2008 10:36:09 PM Hi Paul, My guess: a duplicated field (i.e. select Column1, Column2, Column2...). If that is not the case, how about posting the SQL? Clifford Bass "Paul B" wrote: [Quoted Text] > Setting up an AppendQuery. When I click RUN I get an error message that > says" INSERTINTO contains unknown 'Field25". Checking the SQL code it does > not have 'Field25". INSERTINTO contains only the fields that I put in. > ???????????? > -- > Paul B