I would like to create an update query that updates all fields from table
'A1' (the replica table) to table 'A'.
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
