A
Al Camp
In your Make query, you choose the names for the fields, in the Append query
you indicate what field in the old table will update what field in the
append table. So, City in the old table could append to the Town field in
the append table... thus changing the name.
hth
Al Camp
you indicate what field in the old table will update what field in the
append table. So, City in the old table could append to the Town field in
the append table... thus changing the name.
hth
Al Camp