I have a query that filters one month of daily data from a table. Fields include DAY: 1,2...31 and cumulative flow FLOW: 1000, 2500, 3000 etc
I want to be able to get the daily flow. i.e. day 1 is (2500-1000) = 1500; day 2 is (3000-2500) = 500 etc.
I believe someone on here did this many years ago but I cant find it.