Problem with Table updation

Hi,

I have the following requirement

I have a table with two columns “Amount” and “Quantity”

Amount Quantity

0 34

4 76

7 30

5 52

Here is the requirement—

When there is “0” in “Amount” column in FIRST record, then I have to update “Amount “ field by replacing index 1 value of Amount wthl index2 value of Amount

Index 2 value with Index 3 value etc…and fill index n value with 9.99. And“Quantity” should remain the same.

Output should look like this.

Amount Quantity

4 34

7 76

5 30

9.99 52

Can anyone help me on this. Thanks in advance.

-Padma