running totals/calculations queries 1

[markbrum]

Hi,

I need a field which keeps a running total when a form is filled in i.e.

ref value total
1 £12.00 £12.00
2 £9.00 £21.00
3 -£6.00 £15.00
4 £5.00 £20.00

and alternatively...

ref value loss/gain
1 12 0
2 9 -3
3 10 +1
4 8 -2

could anyone help me with the best way to go about this? Thanks, Mark.

 

[lupins46]

Set the control source of the running total box to:

=dsum("valuefield","mytable","RefNo <= " & RefNo)

use your own field and table names of course.

 

[markbrum]

fantastic, thanks alot!

can anyone help with second part?