AnsweredAssumed Answered

Reporting Challenge...

Question asked by jrobgk1 on Mar 10, 2014
Latest reply on Mar 11, 2014 by philmodjunk


Reporting Challenge...



     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)