G
Guest
I have two tables Table 1 and Table 2. I am trying to append Table 2 to table
1. Table 2 has one extra field that table 1 does not have. When I execute the
append query, it gives the following message:
"The INSERT INTO statement contains the following unknown field name: <field
name>. Make sure you have typed the name correctly, and try the operation
again. Error 3127)"
My understanding was that an append query can append records even when some
of the fields do not exist in the other table
1. Table 2 has one extra field that table 1 does not have. When I execute the
append query, it gives the following message:
"The INSERT INTO statement contains the following unknown field name: <field
name>. Make sure you have typed the name correctly, and try the operation
again. Error 3127)"
My understanding was that an append query can append records even when some
of the fields do not exist in the other table