DSum Function. Please help... 1

[AriefG]

I'm tyring to run a running sum, on Access QUERY.
Here's how the table looks like
Employee ID | Check Date | Amount | DESIRED OUTCOME
1 | 7/1/03 | 500 | 500
1 | 7/5/03 | 800 | 1300
1 | 7/8/03 | 750 | 2050
2 | 7/1/03 | 400 | 400
2 | 7/5/03 | 350 | 750
2 | 7/9/03 | 400 | 1150

I'd like to run a "running sum" on the Amount; grouped by ID, by check date. As shown above, the outcome desired will recognaze the new ID and sort the data by check date.
Anybody can help, please? Thank you...

 

[ConnellG]

Check out the following link for detailed answer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208714

 

[AriefG]

Hello. Thanks for your tips.
But I'm wondering; whether this tip-sheet will work if I have more than 1 variables to play in the equation.
I want mt running-sum to change (start new) when the new employee ID appears.
So, it'll be >> sort data by employee ID, then by check date, and then run-sum. When it reaches the new employee ID, run-sum should back to zero/start over.
Any idea?
Thanks.

 

[ConnellG]

Sorry, all I know is what I read in the Knowledge Base.