Hi fabio.

I get the idea. I thought there might have been a One Line command or function in SQL to do this.. wishful thinking.

Thanks for your help.

Regards,

Gerard



>Hi Gerard,
>
>Cust Invoice Amt Cumulative
>001 100.00 100.00
>023 300.00 400.00
>022 800.00 1200.00
>
>TRY:
>
>Add a Cumulative field set to 0 to the readwrite cursor .
>
>

>CumulativeColumn.ControlSource="this.parent.cumulative"
>
>on grid add:
>
>cumulative = $0
>
>PROCEDURE cumulative_access
> SKIP -1
> IF BOF()
>    REPLACE Cumulative WITH Invoice
> ELSE
>   PRIVATE UpCumulative
>   STORE Cumulative TO UpCumulative
>   SKIP
>   REPLACE Cumulative WITH m.UpCumulative+Invoice
> ENDIF
> return Cumulative
>ENDPROC
>

>
>i dont try, but it can work.
>
>Best is to class it on a Column.
>Fabio