how do i have a water meter rollover in access?

P

pinetree

I have a database that keeps track of flow meters.
The meters are 5 digits "99999". When they rollover I will get a negative
number for my flow. Is there an easy way to reset the meter?
Access 2003
 
B

Bruce

One approach (although not exactly resetting the meter) is to make a form,
bind a hidden text box (txtFlowMeter) to the 99999 field (which could be
formatted with, and add an unbound textbox containing =RIGHT(txtFlowMeter,5).
The number type for the 99999 field could be long integer, allowing for more
than five digits to be stored, but the unbound text box shows you only the
five on the right.
 
G

Gregory Paret

pinetree said:
I have a database that keeps track of flow meters.
The meters are 5 digits "99999". When they rollover I will get a negative
number for my flow. Is there an easy way to reset the meter?
Access 2003
Click to expand...

You could try something like

Flow = [Current]-[Previous]-100000*([Current]<[Previous])

-Greg.
 
Top