Running Sum Problem

[foobar182]

Hi. I am having a problem with running sum. I can set a text boxes properties in my report to have a running sum but the graph in the report only lets me read data from a table for query. How can i set up a running sum that is graphable within access?

Thank you for any help

 

[MikeAngelastro]

I don't believe that this is possible in Access or even in SQL Server unless you use a cursor.

In Access you have to iterate through the recordset and increment the running sum as you go and store the result in a temp table.

 

[aqif]

What u can do is that create a new query based on the running sum query and then just add new colum as runningsum2 which should be like

runningsum*1

or otherwise writting expression like

Select, IDNO, Amount,
Val(Select Sum(Amount) from Tablename where IDNO<=e.IDNO) from TableName as E;

i hope it will give some insight

Cheers!
Aqif