Help

Calculating water usage from current and previous record

Topic Labels: Base design
835 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jon_Stephenson
7 - App Architect
7 - App Architect

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.

2 Replies 2

Yes, but the only way I know of doing this is with a script block.

Thanks - I feared that.