Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Jun 29, 2022
Solved

Using MAX in Update Query

Experts, I am building an update query. I need to update tblFXParent to the MAX value of tblFXRollsChild].[DateSettle] where tblFXParent.IDFXParent=tblFXRollsChild.IDParentfk I am getting an "aggre...
access
  • arnel_gp's avatar
    arnel_gp
    Jun 30, 2022
    you may also try:

    UPDATE tblFXParent Set DateSettleC = DMax("DateSettle","tblFXRollsChild","IDParentfk = " & [IDFXParent])
arnel_gp's avatar
arnel_gp
Iron Contributor
Jun 30, 2022
you may also try:

UPDATE tblFXParent Set DateSettleC = DMax("DateSettle","tblFXRollsChild","IDParentfk = " & [IDFXParent])

Resources