Forum Discussion
Tony2021
Dec 15, 2021Steel Contributor
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 is a manual entry)
Calculated Field:
Balance: [CurrentAmt]+DSum("AmountOfChange","tblLCAmendHistory","letterOfCreditID=" & [tblLCAmendHistory].[letterOfCreditID] & " And [ID] <= " & [tblLCAmendHistory].[ID])
==>The 3rd record doesnt seem to be correct.
thank you for the help!
FYI: this is a follow up to (but I think it is a little different)
- you do not need to use DMax() function,
just do a simple addition:
Balance: [CurrentAmt]+[AmountOfChange]