I need help with an update query that I just can not get my head around right now.
I get data from our HR system to populate the table tblOpLogQry The data may contain the same employee multiple times of when they have been overseas.
I need to update the table/fields (tblPersDetailsOPR) with the data from tblOpLogQry using only the max date row where tblOpLogQry!ID = tblPersDetailsOPR!EID.
Fields to be updated:
ate UPDATE TO tblOpLogQry!RTADate
DeployRTU UPDATE TO tblOpStructure!OPCode
The second field above (OpCode), I would prefer this to be updated with the value from tblOpStructure!OpName where tblOpLogQry![Operation Code] = tblOpStructure!OpCode.
I hope all this makes sense. I have attached an example mdb with some fake data.
Thanks in advance to anyone who may help.