I just seem to be going around in circles trying to figure out this update query design for something I thought was simple.
I want to copy a few fields (surname, firstname, DOB) to the current record from an older record the user has identified with a button on a continuous form.
I know the new record DocID 'TargetDocID' and I know the old record 'PrevDocID'.
I am constructing the SQL statement in VBA but just unsure how I use Select option for both the old and the new record? This is a simple update from PrevDocID fields --> TargetDocID fields
UPDATE DocumentLog dl1 INNER JOIN DocumentLog dl2 On
??
SET dl1.Surname = dl2.Surname etc.
Just not clicking with me at the moment - any help is appreciated.
I want to copy a few fields (surname, firstname, DOB) to the current record from an older record the user has identified with a button on a continuous form.
I know the new record DocID 'TargetDocID' and I know the old record 'PrevDocID'.
I am constructing the SQL statement in VBA but just unsure how I use Select option for both the old and the new record? This is a simple update from PrevDocID fields --> TargetDocID fields
UPDATE DocumentLog dl1 INNER JOIN DocumentLog dl2 On
??
SET dl1.Surname = dl2.Surname etc.
Just not clicking with me at the moment - any help is appreciated.