How to make an update query to use running sum in a field?

[Fekri]

Hi,

I need to update one field of my table by running sum method like this:
3 fields of my table : [bede],[best],[mande]

for example for first 3 record:

Record 1:
[mande]=[bede]-[best
Record 2:
[Mande]=[lastrecordmande]+([bede]-[best])
Record 3:
[mande]=[lastrecordmande]+([bede]-[best])

and should continue to eof.
but I don't know how to do it!!

thanks for any advice and help

Ali

 

[lespaul]

a quick search of the forum for "running total" returned this thread that should help you out
thread701-1237733


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi