I'm not sure where to start on this. I have 2 tables [tblSchDaily] and [tblSchLeaveDates]. I need to use the field in [tblSchLeaveDates] - [WorkLeaveID] and change the fields in [tblSchDaily] - [WorkLeaveID]. I've done simple update queries, but I can't seem to figure out how to go about this one. These are my two tables. I'd like a point in the right direction.