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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update Query Help *urgent* 0
How to Populate Data from a table to another 0
Make table query: [Enter 1] AS Test 1
update query vs make query 5
update query 2
VBA - retrieve data on last create named range from previous inserted named range 0
Update query. Within the same table: populating field 2 from field 6

Back
Top