counting

[Kathy]

DB consists of TblMachine Ondays with Machine Onday ID
(primary), Machine ID(foriegn), Onday date.
tblMachine ID with Machine ID(primary) , PM No, Equipment
Name, etc.
Tasks table with Task ID(primary), Machine ID(foriegn,
Task Notes,etc.
tblTask Dates with Task ID(foriegn), Task Date, etc.

Need to count how many times machine is turned on for
instance 5 times then reset to zero and count to 5 again.
Can anyone please help me??? I AM STUCK and getting heat
to finish this. Thanks in advance. I do not know visual
basics so if there is a way around not using it I would be
forever greatful.

 

[Chris Nebinger]

If I understand you right, you just want to count how many
times it was turned on, restarting at 5 each time.

If so, create a query that does a total count for number
of times it was turned on.

Then, create another query and use the MOD function:

NewValue:CountOfOnDays MOD 5

And the Integer Division:

SecondValue: CountOfOnDays \ 5


The Mod will return the number from 0 to 5.
The second will return the number of times you restarted
at 0.


Chris Nebinger

 

[Kathy]

Okay, then how do I get a message to pop up after 5 uses
to pop-up to inform the operator that maintenance is due.
(ie, Task No xx is due.)
Thanx,
Kathy

 

[Chris Nebinger]

I'm afraid that without the structure of the database, and
when you want this to occur, I don't think I can answer
that. There are other issues to be addressed as well.

You are welcome to send your DB to me at CN--ebinger--@--
Earthlink--.Net (remove the --'s, of course).

I'll take a look, and get back with you with a few more
questions.


Chris Nebinger.

 

[Kathy]

thanks chris, I will send it.

-----Original Message-----
I'm afraid that without the structure of the database, and
when you want this to occur, I don't think I can answer
that. There are other issues to be addressed as well.

You are welcome to send your DB to me at CN--ebinger--@--
Earthlink--.Net (remove the --'s, of course).

I'll take a look, and get back with you with a few more
questions.


Chris Nebinger.


.