Hi, I have one question about access query that I don't know how to solve. I am sending a picture as an example with a couple of data, on which everything is explained.
I have a table where I get the gas meter condition for an individual customer every day, and now I need to calculate the consumption that the customer had in a particular day. And that is actually state of the meter from the observed day - state of the meter from the previous day.
In fact, I need a query that would "subtract" my rows in one column (METER_CONDITION) from day to day and display them as a result.