OraFAQ Forum: Forms » How to get cummulative sum of a column

Home » Developer & Programmer » Forms » How to get cummulative sum of a column (forms 6i, oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get cummulative sum of a column [message #322067]

Thu, 22 May 2008 05:45

bernandas
Messages: 16
Registered: June 2007
Location: Chennai

Junior Member

Dear All,
i have a data block CUMM_SUM(no.of rows - 10). Which contains two columns and a display field(no.of row 1) .

1. ITEM_NAME - PRIMARY KEY
2. QTY - NUMBER

example date
-------------
item_name qty

i1 10
i2 5
i3 15

while entering first item i need to show 10 in the display item,
while entering second item i need to show 15 in the display item,
while entering third item i need to show 30 in the display item, etc...

thanks in advance

Report message to a moderator