Running total query.

Has anyone come up with an easy solution to get running balances in a query?

If I have a table tA that has columns c1 number (pk), c2 number, c3 number

I would like a query that returns the prime key ( c1 ) , c2, c3, and a running total of prior running total + c2 - c3

 c1 c2 c3 running total ------- -------- --------- --------------- 1 500.00 0.00 500.00 ( 500 + 0 = 500 )

2 0.00 450.00 50.00 ( 500 + 0 - 450 = 50 )
3 200.00 150.00 100.00 ( 50 + 200 - 150 = 100 )

Thanks for any input.

Michael Received on Tue May 23 2000 - 00:00:00 CDT