How to calculate a "decreasing total"

[barbaras]

Hi everybody,

I feel a little bit stupid, but I have spent hours to figure how to setup a simple stuff. Indeed, I've a record with a starting total of vacation days (how lucky, I am !) let's say field "tot_days" = 25. In this record I've a field for vacation days I take for my next vacation "used_days" = 8. So, the difference is of course the "avail_days" field.

Ok, now is the trick ! In a new record, I would like that "tot_days" value = the previous "avail_days" value, which generate a new "avail_days" value available for the next record as a new "tot_days" value..etc.....until the "avail_days" = 0

Thank you for any help

[-Queue-]

See attachment for a possible solution.

DecreasingTotal.zip