Running Sum For Selected Records

[sigma788]

Hi, I would really appreciate some help regarding my problem.
It is modified version MS Access Template Personal Account Ledger found on web.
I modified further to suit my needs but now i am stuck on calculating Running sum in queries.

Database is in Access 2003 format (MDB).
I have attached both screen shoot and sample database to explain my problem.

Date range used in queries #11-28-2012# to #11-29-2012#
Thanks.

 

[MStef]

Look at "DemoRuningSumA20022003.mdb" (attachment, zip).
Look at Tables (I added 1 record), Form1 (VBA), Query, Module1.
Open Form1 and try. I made the first query only.

 

[sigma788]

Thanks MStef.
However when applied in actual project the RuningSum goes on increasing.

I used the forms different form event to make wAmount = 0 but when i click on different textbox the form gets refreshed which in turn increases the running sum.
I have attached the picture.

 

[MStef]

It must be you make a mistake somewhere.

 

[sigma788]

I finally got it working.
Here is the sample database if anyone has similar requirements.


Thanks MStef.