Access 2010 append query - error - Microsoft Community

hi all

i trying run append query getting error message i've never seen before -

"the insert statement contains following unknown field name: 'title other' make sure have type name correctly, , try operation again"

it keeps asking me check fields not trying append , won't run. when add field query moves along next field , same that.

any suggestions, simple , stupid has stumped me

tia

nikki

please post table , field names sql view of append query.

Office / Access / Other/unknown / Office 2010