>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