Gerad,

How about using the default value (found in the Field Validation section of the Table Designer) to call a function that returns the required value.

So the function could look at the previous records value & then subtract the new records value to create the total.

Andy