>Dear Sir,
>
>You Wrote
>
>And what if the difference is bigger than value of the first record?
>
>In this case
>
>it should adjust all records
HOW?
Let's suppose you have these values:
24900
70200
71500
but the BALANCE variable is 120 000
What records you must have at the end?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.