HELP with counting

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

Byron

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top