replace fields of one table from another

[Melissa Metcalf]

I apoligize if this is a dumb question, but I am fairly
new to access. I have two tables with a common field of
parcel_id. One table has corrected address info. How do
I replace the incorrect address table with the correct
data in the other table?

Thanksin advance.

 

[Larry Daugherty]

Run an Update query.

I hope that this is just a 'once in a while' kind of activity to update the
table with corrections made elsewhere. Otherwise, there should not be two
tables in the database with the same information.

HTH