>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
>>
Excellent! The simpler, the better. (um... now I see this goes to Stefan...)
I can see how this can go out of hand for multiple fields, because of the need for all the fields to be in the group-by clause. So as long as this can stay in a separate narrow cursor and then be joined to the rest, this can be fast and remain powerful.