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