Recent content by HamishMcD

Thanks Minty. I searched but obviously missed that site! For the record here is the sql that worked. SELECT RawData.ID, RawData.SerialNumber, [Created]-1 AS [DateOf Consumption], RawData.MeterRead, (SELECT TOP 1 Dupe.[MeterRead] FROM RawData AS Dupe WHERE Dupe.[SerialNumber] =...

Hi, I have a table of meter readings taken every day for a number of different meter serial numbers. SerialNumber Created MeterRead 00020704 01/01/2019 00:00 1735000 00030704 01/01/2019 00:00 879000 00049704 01/01/2019 00:00 5632000 00020704 02/01/2019 00:00 1766000 00030704 02/01/2019 00:00...