Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Oct 01, 2022

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.    ...
access
  • arnel_gp's avatar
    arnel_gp
    Oct 02, 2022
    UPDATE tblFXParent SET DateSettleC = DLOOKUP("LastOfDateSettle", "qryFXSettDtCLast", "IDParentfk = " & [IDFXParent])
arnel_gp's avatar
arnel_gp
Steel Contributor
UPDATE tblFXParent SET DateSettleC = DLOOKUP("LastOfDateSettle", "qryFXSettDtCLast", "IDParentfk = " & [IDFXParent])
Tony2021's avatar
Tony2021
Steel Contributor
Oct 03, 2022
Perfect! thank you very much!
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Oct 03, 2022
    you're welcome.

Share

Resources