Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jun 02, 2022

Nz and Dsum

Experts,   How would I add Nz to the below AmendSum Dsum statement?  I think I need to add Nz if the "Amount" is null.  The amount is NULL in tblFXAmends where IDFXfk]= & [ID] (I did set the defaul...
access
  • tsgiannis's avatar
    tsgiannis
    Jun 03, 2022
    Just add Nz in the following concept
    Nz(Dsum("field","table","Criteria"),0)
tsgiannis's avatar
tsgiannis
Iron Contributor
Jun 03, 2022
Just add Nz in the following concept
Nz(Dsum("field","table","Criteria"),0)
  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Jun 03, 2022
    Perfect. I thought I tried that but I guess I made a mistake somewhere. anyways, it works. thank you

Resources