I have an append qery which runs fine . I copied the whole Sql into code of command button using Docmd runsql all fine
I now added a field into the table i am appending to and in the append query added the details. as a query it runs fine and appends all data into nall fields inc. new one but when i copy the sql into code to use as docmd runsql it gives me a message query input must contain at least one table or query!
Surely I have included the table into which to append! If my sql statement is no good why did it work till now? and why does it work when I run it as an append query from the database window?
Thanks

It would be more efficient if you just run your saved query instead of using an SQL statement.

Somehow it does not let me run the saved append query perhaps because too many parameters involved
As it is I solved my problem by rewording the sql and actually removing the table altogether! It now read insert into etc,select exp1 exp2 etc and that was enough to append the contents of various textboxes on a form into a table
Thanks very much for your time and trouble anyway