I am trying to create a query that will compare table values from the same field but from row to row. The field(s) contain(s) values from a logging-type data recorder that records a cumulative total at a moment in time. Could anyone suggest how I could write an expression within a query that will calculate the daily value from each field (the difference between the first and last readings in a given day)?

Help would be appreciated.