Update values from table to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create an update query that updates all fields from table
'A1' (the replica table) to table 'A'.
 
I would like to create an update query that updates all fields from table
'A1' (the replica table) to table 'A'.
Click to expand...

Ummm... ok; but why? Storing data redundantly is essentially NEVER a
good idea!

If you want to do this, you will need a uniquely indexed field (such
as the Primary Key) in both tables. Create a Query joining A to A1 on
this field, and update each field in A to

[A1].[fieldname]

This will only update those records which already exist with a
matching primary key in both tables; if you want to add new records
(instead, or as well) you'll need an Append query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top