This question is a continuation of Q_21149251.html. I've uploaded a sample of the db along with some data to geocities.com. Go thru file manager, username is directorz2002, password is ticket.
I need to set up a 'rollover count' that keeps track of any meter rollovers (re-sets to zero). Here's the thought process:
If the current meter reading is less than the one before it, a rollover has occurred. The RolloverCount field value then needs to be adjusted by "1". Each additional rollover is handles the same way. The ultimate goal of this is to be able to reflect a true meter reading. For example, if the maximum number that a meter can show is 9999 before it re-sets to zero - and it does - I need to show 9999 + the current reading. The formula would be someting like [(LastMeterRead) + (MeterMax * RolloverCount)]. In terms of SQL or VB, how is this best handled and can anyone assist.