Query with a running sum

[is49460]

Hello

I have the following table layout:

Account Date Amount
111 12/1/2009 20
111 12/2/2009 30
111 12/3/2009 40
222 12/1/2009 30
222 12/2/2009 40
222 12/3/2009 50


111 1/1/2010 100
111 1/2/2010 200
111 1/3/2010 300
222 1/1/2010 300
222 1/2/2010 400
222 1/3/2010 500



I need to create a query with a running sum by month, so the output would look as following:

Account Date Running Sum (Calculations)
111 12/1/2009 20 20
111 12/2/2009 50 20+30
111 12/3/2009 90 20+30+40
222 12/1/2009 30 30
222 12/2/2009 70 30+40
222 12/3/2009 120 30+40+50
111 1/1/2010 100 100
111 1/2/2010 300 100+200
111 1/3/2010 600 100+200+300
222 1/1/2010 300 300
222 1/2/2010 700 300+400
222 1/3/2010 1200 300+400+500


Any suggestions would be greatly appreciated, Thanks!!!

[RuralGuy]

A report can do this.

[joshynaresh]

it is imposible in query?

[June7]

Review http://support.microsoft.com/kb/290136