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] =...