Suppose I have a table with 1000 records and 2 numeric fields (I call them columns belo).
The first column has random data in it, integers no bigger than 100, no smaller than
0. Starting with the 7th record record, I want to replace each record in second column
with the sum of the 6 preceeding records, from column 1.

I could do this with a do while loop, of course, but is there a quick way to do this
using a repl all command, one that knows how to take the sum of the proceeding 6 records
in column 1?
Thanks
Steve