Hi all. I'm trying to fix an append query that generates the right recordset just fine, but on run I get the error: </PRE>
"The INSERT INTO statement contains the following unkown field name: '[CompanyDescription]'. Make sure you have typed the name correctly, and try the operation again." I got this error with that field under a different name (same name both tables.) Here's the sql:
</PRE>
So the field names match in both tables, the source is a find unmatched query, and all field types are text. Any ideas?? Thanks in advance...Kevin</PRE>
"The INSERT INTO statement contains the following unkown field name: '[CompanyDescription]'. Make sure you have typed the name correctly, and try the operation again." I got this error with that field under a different name (same name both tables.) Here's the sql:
Code:
</PRE>
INSERT INTO tblSymbolsMain ( Symbol, [CompanyDescription], [Security Type] )SELECT qryNewSymbolsToAddToMainSymbols.Symbol, qryNewSymbolsToAddToMainSymbols.CompanyDescription, qryNewSymbolsToAddToMainSymbols.[Security Type]FROM qryNewSymbolsToAddToMainSymbols;</PRE>
So the field names match in both tables, the source is a find unmatched query, and all field types are text. Any ideas?? Thanks in advance...Kevin</PRE>