Results 1 to 2 of 2

Thread: Help

  1. #1
    Join Date
    Dec 2011
    Posts
    13

    Unanswered: Help

    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?

  2. #2
    Join Date
    Dec 2011
    Posts
    13

    Help

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •