Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Dec 15, 2021

Running Balance query

Hello experts,    I have a query that shows a [Balance] but I am not sure why the math is off. I enter an amount [CurrentAmt] (this is a manual entry) I enter an amendment ([AmountOfChange] (this...
access
  • arnel_gp's avatar
    arnel_gp
    Dec 16, 2021
    you do not need to use DMax() function,
    just do a simple addition:

    Balance: [CurrentAmt]+[AmountOfChange]
arnel_gp's avatar
arnel_gp
Steel Contributor
you do not need to use DMax() function,
just do a simple addition:

Balance: [CurrentAmt]+[AmountOfChange]
Tony2021's avatar
Tony2021
Steel Contributor
Dec 16, 2021

arnel_gp 

Perfect!  the solution was so obvious.  I was thinking too much into it.  I am going to ask another similar question. 

Resources