counting

Kathy · May 17, 2004

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 · May 17, 2004

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 · May 18, 2004

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 · May 18, 2004

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 · May 18, 2004

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.

.