Running sum in query

[chavez_sea]

Good day,


I have a form that calculates running sum when inputting data into a cash account table. There is an expenditure , and a deposit column, and I would like to run a query that would give me the running sum also, so I can run a report showing the entire cash book with running balance. There is a Autonumber field to keep record of the transactions. THis is what I have in the running sum field on the form : RunSum([Form],"Payment FIle No",[Payment FIle No],"Deposit")-RunSum([Form],"Payment FIle No",[Payment FIle No],"Amount")
Any help or alternative method would be appreciated.

Thanks Cristina

[June7]

So you have custom functions that do the running sum on form - did you try these in query?

Report textbox has RunningSum property. That's the easiest approach for what you want.

[chavez_sea]

That code was given to me. I dont know to write it. When I put that in the query it shows up an error.
Can you give me detail instructions.

Thanks

[June7]

I don't know purpose of argument for which the [Form] parameter is provided. Would have to see the function code. Suggest you instead explore the RunningSum property.

[chavez_sea]

The purpose of the code in the form is to show the cash balance after the expenditure transaction. WOuld I please be allowed to send a copy of the dbase.
Thanks

[June7]

Running sum is not simple in form and query. A total at bottom is easy.

One method for running sum using DSum https://support.microsoft.com/en-us/kb/290136 - be aware domain aggregates can perform slowly.

Do web search for more info.

To provide files, follow instructions at bottom of my post.