Thanks Everyone,

Both solutions work, so I guess all I have to do now is choose the one to use.

Regards
Doug Johnston


>Try a SQL Self-Join similar to the below example:
>
>

>CREATE CURSOR testdata (name c(1), amt y)
>INSERT INTO testdata values('a',1)
>INSERT INTO testdata values('b',2)
>INSERT INTO testdata values('c',3)
>SELECT x1.name, x1.amt, SUM(x2.amt) RUN_BAL FROM testdata x1 JOIN testdata x2 ON x2.name <= x1.name GROUP BY 1
>

>
>>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