Updating a master file in Access

I have a table with a list of employee records, each identified by a unique id, and there are 9 other fields on the table.  There are around 25,000 records.  I have to maintain this master table as updates to the records are submitted to me.  The structure of the update tables is the same as the master table and between 1 and 9 of the non employee id fields may have changed.  Is there a query that can be run to elegantly update the master table?  Please see attached for a sample of the master table and update table.
EE-update-master-file.mdb
GIStewartAsked:
Who is Participating?
 
peter57rCommented:
If you are always going to get all fields then just update all fields.

Update Master as M Inner join  [Update] as U on
M.Employee_id = U.Employee_id
Set M.flda=u.flda, m.fldb= u.fldb, M.fldc=u.fldc, m.fldd= u.fldd,M.flde=u.flde, m.fldf= u.fldf,
M.fldg=u.fldg, m.fldh= u.fldh,M.fldi=u.fldi, m.fldj= u.fldj
0
 
GIStewartAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.