Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running Difference (Access2000)

    I have a table with serial numbers, meter readings, and date
    The date is the Friday of every week.
    The meter readings are always ascending in value.
    Is there a way to find the running difference by week for the meter readings?
    I'm looking to chart the usage by week for each serial number on a line graph.
    I'm working on some queries but it seems I'll have to create a new query each week the way I'm doing it.
    Does anyone have any ideas,
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Running Difference (Access2000)

    A variation on <post#=274555>post 274555</post#> should do the trick. If you would like more assistance, post back with information about the field names in your table, then we can give a reply for your specific situation.

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running Difference (Access2000)

    Hi there...

    I'm not sure if I am clear on what the serial number represents, but for this purpose I'm assuming that it is a number that refers to the location of the meter being read...

    First of all, I have to give complete credit to Hans! <img src=/S/starstruck.gif border=0 alt=starstruck width=15 height=15>... He posted a response to someone a week or so ago that was along these lines... I had been trying to figure out how to do this comparing data from previous and current record stuff in one query, for sooooo long!... I always end up doing it programmatically, and all thanks to Hans <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>, I don't have to do it anymore... I've been playing with his example and altering it for your situation (as I see it)... I hope it makes sense and gives you a start at least....

    Have a great weekend! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Let me know...
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running Difference (Access2000)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> ... I should have known you'd beat me to it!... <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    Have a great weekend Hans!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Running Difference (Access2000)

    But you added a demo, I didn't <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  6. #6
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running Difference (Access2000)

    Thanks to both of you, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    This will do exactly what I need.

    Later,
    Scott

Posting Permissions

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