var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tracking Electricity Consumption
I am trying to build a database that tracks 5 customers. The table has the following fields:
3. Meter Read
How can I calculate the consumption between reads for each customer? I was able to do it with only one customer using:
Couple of ideas for you. You can place that code directly into a query column, at the very top something to the effect of Consumption: [code]
Secondly you can place that code as the control of a text box in a report. Assuming you have the correct information in your queries it should populate it for every record you have in the report.
Hope that helps!