Hi,

I am displaying a table in a grid, but i would like a calculated field to also be displayed. For example, the table has a column called Amount, I would like a new column called Running Balance recalculating the previous running balance plus current amount for the new running balance...

RECNO   AMOUNT   RUNBAL
1         1.00     1.00
2         2.00     3.00
3         3.00     6.00

...I am having problems coming up with an SQL for the above( select amount,?????? as runbal from table into cursor). I hope someone can help.

Regards
Doug Johnston