var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a table that tracks electricity usage. The table has 2 columns, Month and Reading. How can i calculate the usage between months in a query?
Here is what i got so far:
kwh: IIf([reading]=0,0,([reading]-DMax("[reading]","[tblelectric]","month<#" & [month] & "#")))
the problem i run into is when i have a month that the reading is zero. Anyone have any ideas on a work around?