I am working on a solution for a company that wants to track their use of utilities during a given period, which the measure every day. This used to be a paper based challenge, with manual entry to a spreadsheet that kicked out final values at the end of a given time period.
I feel like this should be an easy thing to accomplish, however, I am running into difficulty conceptualizing the final "report". I have the table set up to take individual readings of different utility types as new records. However, to be able to show, on a printed page, the difference between one record and another over a time period seems, well, like there are a million ways to do it, but none feel "right".
Does anyone have some guidance as to a good way to approach that problem?
FTR: we are on FM 13. The table has a _PKUtilityID, UtilityType, UtilityMeasure, Date(timestamp), Day(calculated), Week(calculated), SumOfUtility(Summary of UtilityMeasure), and CountofUtility(CountNumber of records)