Subtract one days reading from the next

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a meter that is read daily and I need to calculate the difference in
todays reading from yesterdays reading.
 
Tim said:
I have a meter that is read daily and I need to
calculate the difference in todays reading from
yesterdays reading.

We could guess, but it would be better for you to explain what data you are
storing and how you are storing it, and what you want to do with the
difference once you calculate it.

Larry Linson
Microsoft Access MVP
 
Larry Linson said:
We could guess, but it would be better for you to explain what data you are
storing and how you are storing it, and what you want to do with the
difference once you calculate it.

Larry Linson
Microsoft Access MVP


Thanks for replying
the readings are on a flow meter that measures million gallons per day. It
works on a 4 to 20 millamp signal and increases the count based on the
signal. I need to be able to take the beginning reading and subtract that
from the ending reading. I can do that in a form by referencing todays date-1
to get the the previous days reading but I really need to store the data for
later use in order to average the monthly and weekly totals. The first,
second and third week all contain seven days, but the last week may have ten
which would still count as a week in our reporting requirements. So I guess I
have two problems.

Again Thanks for your time.
 
Back
Top