Calculation script using data from previous entries
Right i've got a table for logging kms for a company car.
Each time the person logs somthing new he's adding the date and the reading of the odometer.
I want to perform a calculation per entry that will subtract the odometer reading from the previous entry from the reading on the current entry to give a total distance travelled.
I can't seem to find a scrip that will allow me to subtract values from previous entries from within the same field.
I'm sure this will probably be pretty simple!
Thanks all (Probably Phil)