Variable append.m_exp1 expression - Field is not recognized

[Jeff Carroza]

I am trying to append records from one table to another. When I run the append operation I get the Error

Error running Append Operation
Variable append.m_exp1 expression - Field is not recognized

I have attached a screen shot of the error and append screen. The transaction table was imported from excel. The Master table is an existing table. I do this once a year, always with a new transaction table. I've never had a problem in the past. The fields all append intact. Thanks in advance for any help.

Jeff

[johnkoh]

Jeff,

I think that your table name is not right which has " - , ( ) ". try again after change the table name with Underline and without "( ".