replace fields of one table from another

  • Thread starter Thread starter Melissa Metcalf
  • Start date Start date
M

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.
 
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
 
Back
Top