Calculate a Running Sum

[burrina]

I need to add another field to my calculated running sum, the filed name is frequencyamount . Here is my code as it is now without adding the new field.


RegID is the Primary Key on the form but is of course based on my table TReg Amount is the running sum calculated field.


=RunSum([Form],"RegID",[RegID],"Amount")

[alansidman]

Here is a template for a checkbook I use. It has running sums in both the main form and in the report. The report is based on a query that contains the running sum.

[burrina]

Thank You for that.A little bit different approach but almost the same. I appreciate it!

[burrina]

I have come up with a better idea to do this.I created a new form with ONLY my needed criteria on it. I now need as before to add the frequencyamount to this formula.

=RunSum([Form],"RegID",[RegID],"Amount")