>I need to make a running total cursor that will be fed into a graph. For example, if I have this:
>
>

>datefield          numfield
>01/01/98        4
>01/08/98        10
>01/15/98        6
>

>
>...the output would be:
>

>datefield          runningsum
>01/01/98          4
>01/08/98          14
>01/15/98          20
>

>

SELECT t1.d, sum(t2.value) ;
FROM table t1 INNER JOIN table t2 ;
ON t2.d <= t1.d ;
GROUP BY t1.d

-Mike