Updating Data in a Table on the basis of another Table

Help Me! This probably seems like a stupid question but as you will tell I'm not proficient at Access!

Basically I would like to update certain records in one table by replacing the data with that from another table where the surname and firstname match.

It is as simple as that. I've tried doing a query where I add both tables and join both the firstname and surname and then choose append but it comes up with an error message that doesn't specify the exact problem.

Please help a poor novice to learn!!

D

Run the following query (SQL View)

UPDATE Table2 INNER JOIN Table1 ON Table2.FName= Table1.FName and Table2.SurName= Table1.SurName SET Table2.FIeldToUpdate= [Table1]![FieldToUpdateFrom];

S-

Thanks for this. I actually found the answer on the Microsoft website on the following page = URL which showed me how to do it using an update query and using these lovely babies '[]'. Not quite up to SQL level yet but will defo try next time as it seems a lot easier/quicker than what I had to do. Thanx for speedy reply! D

Hey FYI

The easiest way to become better at SQL is evertime you create query in Access, look at the SQL view and read what the code says it is doing, in relation to what you created the query to do.

S-

Yes a not so little database man called Dave M used to tell me that one, and I have to say that I miss him and his advise but I haven't been able to speak to him since he asked his ex bird (my friend) not to make contact. Ashame really all round. Anywayz thanx again, I shall take heed this time!!

D