Append query not working

[rayted]

Hi guys,



Can anyone help me write my append query, here is the SQL:

INSERT INTO [In Progress - Responding tbl] ( [In Progress - Responding tbl] )
SELECT [In Progress-Responding].Received
FROM [In Progress-Responding];


I get an error message say the insert into field name is not valid? but the table exists!

Thank you!

[isladogs]

So you have a field in a table with exactly the same name (In Progress - Responding tbl)
You want to append data from a field called Received in another almost identically named table In Progress-Responding

If that's what you have /want, you really need to do something about your naming convention.

EDIT: Full answer now given in separate post https://www.accessforums.net/showthr...868#post389868