APPEND query returns insert into statement error

[laks21277]

Hello,
I have 2 tables, PROJECTS and NEW PROJECTS. They obviously are the main table and the table to be appended. I actually created the NEW PROJECTS by copying the structure of the PROJECTS table to avoid any name errors.
But after creating a query which takes all the data from the NEW PROJECTS, if I convert this query into an APPEND query and run it, it gives me the following error:-

The INSERT INTO statement contains the following unknown field name: 'DEVELOPMENT COST'. Make sure you have typed the name correctly and try the operation again.

I have included all the fields from the table into the query by using the * in the table fields list.
This is the SQL view of the query.
Please help me sort out this issue.

Thanks and regards

Lakshmi Vinay

 

[Uncle Gizmo]

Try removing the Space from both Field Names

 

[mjreiman]

I have had similar problems with the append query feature. What seems to solve it is pretty much already mentioned. One of the best things to learn and get into the habit of doing with access is instead of naming ANYTHING (this includes table/query names as well as field name) with no spaces. Such as NewProject or New_Project. With queries, multiple words must be in brackets like [New Project] in order for it to recognize it.

 

[laks21277]

Hello
Thanks for the response. I realised it afterwards that sometimes when I create the queries using the wizard rather than thru the design view was giving the square brackets around the field names. And that was when the query when converted into an append query and run was giving me this error.
This didn't happen when I created the query in design view at all. Still have no idea why the wizard mechanism is giving me this error.

Thanks

Laks21277

 

[Hndz80]

Hello I am getting same error, however my field name has no spaces. Not sure how to fix. I am not using the wizard, using design view.

 

[JHB]

Show a printscreen of the error you get, zip it then you haven't post 10 post yet.
Show also the SQL-string.