[comp.databases] *** PARADOX question on table manipulation

lee@minnow.sp.unisys.com (Gene Lee) (02/19/91)

Can anyone tell me how to do the following in Paradox?

I have a table like this;


		Date       Price
	________________________
     1/1/91         10.00
	 1/4/91         10.00
	 1/8/91         15.00
	 1/20/91        10.00
	   .
	   .
	   .

What I want is to generate a table with a third column which is the running
sum of the Price column ,  Like this:


		Date       Price       new
	_________________________________
     1/1/91         10.00     10.00
	 1/4/91         10.00     20.00
	 1/8/91         15.00     35.00
	 1/20/91        10.00     45.00
	   .
	   .
	   .

What I'm after is being able to graph the new column against the date
column.
Thanks in advance to anyone who can help.

Gene W. Lee

-- 
Gene Lee               UUCP: ...!uunet!s5000!minnow!lee
Unisys Corporation               
Phone: (612) 635-7147     CSNET: lee@minnow.SP.Unisys.Com
If not for the courage of the fearless manager, the paycheck would be lost.