Update Records Query

[crhodus]

I have a SQL table named UserMaster that I linked into an access mdb. Inside the mdb, I have a backup of UserMaster from a couple of weeks ago. I'd like to update the SQL UserMaster.LastModified date with the date that is in the Acdess Backup UserMaster.LastModified date where the UserId is equal in both tables. The UserID is unique. How can I go about creating a query like this? I'm not haveing any luck with my searches.

Thanks,
crhodus