T
Tim
I have a meter that is read daily and I need to calculate the difference in
todays reading from yesterdays reading.
todays reading from yesterdays reading.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Larry Linson
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
T
Tim
the readings are on a flow meter that measures million gallons per day. ItLarry 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
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.