[RESOLVED] ms access query/ form accumulate value

[nagasrikanth]

Dim rst As Recordset
Dim prevval As Double
Set rst = CurrentDb.OpenRecordset("select * from table1")
While Not rst.EOF
rst.Edit
    rst("accum") = prevval + rst("price")
rst.Update
prevval = rst("accum")
rst.MoveNext
Wend

where table1 is ur table (not a query) containing the items and values..

If ur problem got resolved,then please rate the post..