update a table

[rinova]

I need some help with copying/updating data from a database table to another.
Details:
I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank.
I have a MS Sql Database that contains a table with most of the missing MS Access table dependents Social Security numbers.
How can I take the Dependents social security number from MS Sql Database and copy/update the MS Access table.
I tried the sql code below created from MS Access and it matches 453 records out of 460 dependent social security numbers but how do I update qryGHIAccuracyFile_MissingDepSSN.SSN with the social security number from dbo_depfile1.dep_depend_ssn

 SELECT dbo_depfile1.dep_depend_ssn, qryGHIAccuracyFile_MissingDepSSN.SSN
 FROM qryGHIAccuracyFile_MissingDepSSN LEFT JOIN dbo_depfile1 ON qryGHIAccuracyFile_MissingDepSSN.MemberSSN = dbo_depfile1.dep_ss_nbr
 WHERE (((dbo_depfile1.dep_first)=[FirstName]) AND ((dbo_depfile1.dep_last)=[LastName]));

Can anyone help me with updating MS Access table dependent blank SSN’s with SSN in MS Sql Database.
Thanks,
Rich

 

[Rx_]

http://www.btabdevelopment.com/ts/2010UpdateQuery
Look at this first, then ask a specific question if it doesn't get the complete answer for you.

 

[rinova]

I think I figured it out. I used the Sql Code below and it worked. I also used this http://office.microsoft.com/en-us/access-help/update-data-by-using-a-query-HA010076527.aspx#BM5 to help me as well.

UPDATE [Test tblGHIACCURACYFILE] LEFT JOIN dbo_depfile1 ON [Test tblGHIACCURACYFILE].MemberSSN = dbo_depfile1.dep_ss_nbr SET [Test tblGHIACCURACYFILE].SSN = [dbo_depfile1].[dep_depend_ssn]
WHERE ((([Test tblGHIACCURACYFILE].SSN) Is Null) AND ((dbo_depfile1.dep_last)=[LastName]) AND ((dbo_depfile1.dep_first)=[FirstName]));

Thanks,
Rich

SELF HIGH FIVE