I have a table that has multiple energy use readings throughout the day. So each day may have multiple readings.
How do I create a query to show daily usage?
I need to subtract the max record of X day from the max record from the previous day to ensure I include overnight usage (when no readings are taken).