HELP with counting

  • Thread starter Thread starter Bugbyte
  • Start date Start date
B

Bugbyte

I have built a access data base for Preventive maintenance.
My problem is this. Some machines need to certain tasks
performed after 5 uses, 30 uses, some daily, monthly, etc.
For now I am trying to figure out the 5 use part. I have
them log in each time the machine is used and an ondate is
entered. What I can't get is how to count each time the
machine has been turned on 5 times and needs a task
preformed and some how flags the operator the task is due.
Then resets itself to count the next 5 uses, etc.
Any help I could get would be very much appreiated.
..
 
I would suggest that you could use a Byte type file in
which you start at zero and each time the user logs on or
what ever you have them do to let you know that they have
used the machine, increment the value in this field by 1.
Each time they log on you would check the value of this
field and if the value is equal to the count you want,
notify the user. You would also want some way for the
user to tell you that the required maintenance has been
performed and with that confirmation, you would reset the
value of the field to zero.

HTH

Byron
 
Back
Top