View Single Post
  #2 (permalink)  
Old May 25th, 2006, 02:14 PM
Jack Britton Jack Britton is offline
Registered User
Join Date: May 2006
Location: Renton, Washington, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts


Try this SQL statement:

UPDATE TBL, tblEmployees SET TBL.Firstname = TBL!Firstname, TBL.Lastname = [TBL]![Lastname]
WHERE (((TBL.Firstname)=[tblEmployees]![FirstName]) AND ((TBL.Lastname)=[tblEmployees]![LastName]));

TBL was a test table I set up in Access to make sure it worked. It does. I hope this helps. I don't know what type of RDBMS you are using but this does work in Access.

Jack Britton

Reply With Quote