Good morning,
I'm thinking my issue is probably fairly easy, but I'm getting nowhere and once I get the support from all of you I will probably be somewhat embarrassed for asking.
My table has three fields. (Data from a boiler.)
Date_1
Totalized_Steam
Totalized_Gas
Each evening, at midnight, this data is sent to the database via a plant floor PLC.
Totalized Steam and Gas is just that, these numbers increase daily from the beginning of time.
What I am needing is . . .
Lets say yesterday at midnight my Totalized_Steam value equals 1000
Tonight at midnight it may read 1200
I would like a column in my query that shows I've produced 200 lbs of steam over the past 24 hours. By subtracting Totalized_Steam from tonight's midnight entry from yesterday's
Of course I would need to show this value for each day, (I will be building a rolling 30 day report.)
Any help would be greatly appreciated.