1. ## 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. ## 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. ## 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...

4. ## 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. ## 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. ## 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
•