Simple Problem, Complicated Solution?

[douginiraq]

I have a need to track the amount of chlorine we use daily.

I have generated a table and form to collect the data and a generic report to display the collected data.

What I am struggling with is as follows:

As the chlorine cylinders empty their respective weights decrease. Then they reach the "empty" level the system automatically switched over to the second pair of tanks (Hence A & B).

What I am trying to figure out is when the tanks are changed with full ones and the weight goes back to 150lbs the previous balance of two needs to not be counted as "usage"and to reset the reading to 150 lbs.

Based on the attached sample data I should see the following totals:

7 NOV - 41
8 NOV - 81
9 NOV - 39
10 NOV - 60
11 NOV - 43
12 NOV - 88
13 NOV - 30
14 NOV - 35
15 NOV - 50
16 NOV - BLANK

Also I would like to hide all of the no Values in the "Change Cylinder" columns.

I would like to add that if when the change cylinder was set and it automatically reset the counter to 150 for that cylinder it would be great!

Cheers!