I have a table with a date and numeric field. It tracks a water meter reading. Is there any way that I can calculate usage by taking the current record meter reading and comparing the difference between that and the previous records meter reading then calculating the number of days difference between the current and previous record to come up with a litres usage per day?

Thanks in advance.