RE-Post

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

My 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.
 
It is difficult to understand how your db works. Could you clarify?
What entries in what tables indicate that the machine was turned on?
What do you mean "count 5 times, then reset"? How many times the machine
was turned on in the increments of 5?

I am guessing that you should make a GROUP BY query, querying whatever
table logs machine turn-ons, grouping by MachineID and return Count of
these IDs.

Pavel
 
When an operator turns on a machine they access MachineID
form and pick a PM No which displays all significant data
about that machine. They then enter the date in a subform
called onday date. wat i need is how to tell if that
machine has been turned on 5, 30, etc timesand use my
tasks table to show what tasks are due for that date. not
all machines are used every day hence the uses. some tasks
are done in daily , six month and annual increments. those
have due dates for maintenance and those i can pick out
with a querie.
thx,
Kathy
 
I think you could try to use a query such as

SELECT Count([Machine ID]), [Machine ID] FROM [TblMachine Ondays] GROUP
BY [Machine ID]

This should give you the count of the number of times the machine was
logged in the table.
You can build on this and add criteria to limit dates between which to
consider turn-ons, etc.
Pavel
 
Thanks pavel, I will try that.
Kathy
-----Original Message-----
I think you could try to use a query such as

SELECT Count([Machine ID]), [Machine ID] FROM [TblMachine Ondays] GROUP
BY [Machine ID]

This should give you the count of the number of times the machine was
logged in the table.
You can build on this and add criteria to limit dates between which to
consider turn-ons, etc.
Pavel
When an operator turns on a machine they access MachineID
form and pick a PM No which displays all significant data
about that machine. They then enter the date in a subform
called onday date. wat i need is how to tell if that
machine has been turned on 5, 30, etc timesand use my
tasks table to show what tasks are due for that date. not
all machines are used every day hence the uses. some tasks
are done in daily , six month and annual increments. those
have due dates for maintenance and those i can pick out
with a querie.
thx,
Kathy was
turned on? Onday
ID would
be
Click to expand...
.
Click to expand...
 
Back
Top