Recent content by scchas

How do you do what you are talking about. I understand the logic. How do I make a query or if it is programming do what I want? I need something along the line of if val1 < val2, then (val1 + 100000)-va12 else val2-val1 How do I fix the first reading record as val1 and the next reading...

I have electric meter readings which for one meter can go like this: 10/10 99509 10/17 704 10/24 1513 The meter tops out at 100000 and then starts over so the actual difference between 1195 ((100000-99509)+ 7040. I need to calculate this for almost 20 meters and I tried using a...

Thanks for your help. This appears to work.

Thanks, but I do understand that. How would I do the calculation in the query? That's what I really need to know. I didn't make that clear in the original message.

I am setting up application for determining electricity usage and I need to know how to calculate the difference of the meter reading this week against the meter reading of the previous week. I am not sure I am setting up the table properly to do this. Thanks in advance for any helpful advice.