Forum Discussion
Update Query
Hello experts, I have an update query SQL below and I am getting an error message. Do you see anything obviously wrong with it? I am not sure why I am getting that error msg in the screen shot. ...
- UPDATE tblFXParent SET DateSettleC = DLOOKUP("LastOfDateSettle", "qryFXSettDtCLast", "IDParentfk = " & [IDFXParent])
Ok that makes sense. qryFXSettDtCLast is an aggregate query. Do you happen to know of a workaround? I definitely need to update tblFXParent.DateSettleC to the LAST of Date Settle as found in [qryFXSettDtCLast]
If it helps, below is my sql of qryFXSettDtCLast
SELECT tblFXRollsChild.IDParentfk, Last(tblFXRollsChild.DateSettle) AS LastOfDateSettle
FROM tblFXRollsChild
GROUP BY tblFXRollsChild.IDParentfk;
