plz , plz help me in running sum

[zibzaba]

is there anyone kind to help me !
plz help me in running sum.
i want running sum of field "Diff" in "stock" query. i am uploading database in 2002 format
thanx

 

[Brianwarnock]

Running sums are difficult in queries but very easy in Reports, so why not use Reports?

Brian

 

[MStef]

Look at "DemoQryRunSumA2000.mdb" (attachment, zip).
Open "Form1" and try.

 

[zibzaba]

sorry to say that mstef's db isnt useful because it doesnt give results correctly when we view query.
so plz brian help me.
and for reports, there isnt continous running sum but it is only for present values in report not all the previous values.

 

[Brianwarnock]

and for reports, there isnt continous running sum but it is only for present values in report not all the previous values.

I didn't understand this, the running sum in the Report is only current Report values.

Mstef's technique does not work if the query is rerun.
Assuming that the outgoing is 0 for the first record then A2 can be initialised, I have done that and amended your query, but have also included a report based on your initial query.

Brian

 

[MStef]

Hello zibzaba!
Look at ""DemoQryRunSumA2000.mdb", a new one, (attachment, zip).
I added Reprot1, and Report2. You must go via Form1.
Open Form1 and try.
It must work, but you must know something about VBA.
I forgot, you cna exclude the code "A2 = 0" in VBA, (command8).