2nd Attempt: Updating one table from another one.

  • Thread starter Thread starter Burger King
  • Start date Start date
B

Burger King

Hello

I have one main table with about 10000 records and I am
trying to update only about 2000 from a different, updated
table some temp created before he left. How can I update
this information from the more recent table to another?
Both have ID's as primary keys, both have the same IDs for
the same clients, I tried the update query and all that
but to no avail... Any assistance would be appreciated!
 
Hello

I have one main table with about 10000 records and I am
trying to update only about 2000 from a different, updated
table some temp created before he left. How can I update
this information from the more recent table to another?
Both have ID's as primary keys, both have the same IDs for
the same clients, I tried the update query and all that
but to no avail... Any assistance would be appreciated!
Click to expand...

You don't give any table or fieldnames so this is necessarily vague,
but:

Create a query joining Main to Temp by ID.
Change it to an Update query.
On the UpdateTo row under each field that you want updated, type

[Temp].[fieldname]

The brackets are essential (if you put just temp.fieldname it will
update all the records to the text string "temp.fieldname"!!)

Do this on a COPY of the database first, just to make sure it's
correct; if you overwrite the data incorrectly it's gone forever.

If you're still having trouble getting the update query to work please
open the query in SQL view and post the SQL here.

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