RUNNING SUM

[kutibo]

Hi,
I need to have a runnning sum for each record in a subform. I have a beginning balance and entiries. I want to add each entry and display the answer for each subsequent record. For example, if each entry was 100. The results would be: 100, 200, 300, 400 etc. The entries are grouped. They are grouped by with a combination of two fields which are numbers. So the number of entries vary from group to group. I tired dsum but that won't do it. I also used sql, which worked, but i need to be able to create new records so i can't use a query. Thanks for your help
kutibo

 

[kathryn]

I have never heard of doing a running sum in a form; just in a report. Can your users use a report instead of a form? Kathryn

 

[JoeMiller]

Rather than a running sum are you instead trying to take all the documents for a particular customer on the subform and add them up to come up with a total? For instance, pull up ABC company, they have 3 documents with $15 on each line and show a total on the main form for $45 on ABC company... If that's the case, DSum will work, you just need to write code that updates the control after the user enters a new line item in on ABC Company. Joe Miller
joe.miller@flotech.net