I have searched the net but not been able to get my head round this one,
I have a table of work carried out on a vehicle, fields include date of job, mileage or hours of vehicle when job was done etc, I would like to calculate how many miles travelled between previous job and current job.