If you have appended information into a table but forgot to a field how to 

you update, or append more information from another table but referencing 

it with information already entered.

You need to run an update query. Itll look something like the following:



UPDATE Table_new INNER JOIN Table_old ON Table_new.UniqueID = 

Table_old.UniqueID SET Table_new.FieldToUpdate = [Table_old]!

[FieldToUpdate]



(replace as appropriate!)