Running Difference (Access2000)

Topic

New Reply

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

Reply | Quote

Replies

A variation on post 274555 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.

Reply | Quote

… I should have known you’d beat me to it!…
Have a great weekend Hans!

Reply | Quote

But you added a demo, I didn’t

Reply | Quote

Thanks to both of you,
This will do exactly what I need.

Later,
Scott

Reply | Quote

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! … 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 , 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!

Let me know…

Reply | Quote