K
keef
Am trying to include a combo box on my form that produces
a running total. I have two fields (called on and off) and
I need to calculate the difference between the fields as a
running total.
Have tried the equation: =Sum([on]-[off]) in the combo box
but this only produces a record specific total.
ie: if The difference in the first record was 2 and in the
second record it was 1 then the Running totals box should
show 3 on the second record, but is only showing 1.
Also tried a second combo box with the equation:
=Sum([running total]) which returns the right value in the
second record, 3 in the above example, but if you flick
back to record one it still shows 3 when i want it to show
2.
with this setup, in datasheet view, the equations change
the whole field according to the latest record rather than
increasing incrementally by the difference between the two
fields.
Not sure I explained it very well but any ideas or
suggestions would be very welcome else i might lose all my
hair...
a running total. I have two fields (called on and off) and
I need to calculate the difference between the fields as a
running total.
Have tried the equation: =Sum([on]-[off]) in the combo box
but this only produces a record specific total.
ie: if The difference in the first record was 2 and in the
second record it was 1 then the Running totals box should
show 3 on the second record, but is only showing 1.
Also tried a second combo box with the equation:
=Sum([running total]) which returns the right value in the
second record, 3 in the above example, but if you flick
back to record one it still shows 3 when i want it to show
2.
with this setup, in datasheet view, the equations change
the whole field according to the latest record rather than
increasing incrementally by the difference between the two
fields.
Not sure I explained it very well but any ideas or
suggestions would be very welcome else i might lose all my
hair...