Stefan,

that's a really neat way of doing it! Thanks.


>>How do I run a running total in column amount of my grid?
>
>You can get a running-totals column by doing a self-join:
>
>

>CREATE CURSOR temp (idField Int, amount Num(15,2))
>INSERT INTO temp VALUES (1, 11.3)
>INSERT INTO temp VALUES (2, 8.7)
>INSERT INTO temp VALUES (3, 10)
>
>SELECT T1.idField, T1.amount, SUM(T2.amount) ;
>    FROM temp T1 ;
>        JOIN temp T2 ON T2.idField <= T1.idField ;
>    GROUP BY 1, 2 ORDER BY 1
>

>
>
>hth
>-Stefan