Re: RE-Post

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kathy (anonymous_at_discussions.microsoft.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 06:01:40 -0700

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
>
>Kathy wrote:
>>
>> 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
>> >-----Original Message-----
>> >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
>> >
>> >Kathy wrote:
>> >>
>> >> 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.
>> >.
>> >
>.
>

Relevant Pages

  • Re: RE-Post
    ... I think you could try to use a query such as ... Kathy wrote: ... wat i need is how to tell if that ... six month and annual increments. ...
    (microsoft.public.access.queries)
  • Re: Halting a Repeating Macro on Not Found
    ... > Hi Kathy, ... > It was the Update Query using the Replacefunction that I was referring ... > Steve Schapel, Microsoft Access MVP ... >> Therefore, I feel this repeating macro solution is not the way to go, ...
    (microsoft.public.access.macros)
  • Re: Select Last payment date and amount of a group
    ... To test the query I create a table named Kathy with fields as you outlined. ... AutoIncrementingPaymentID ... I want a query that will return the LAST payment date and dollar amount ...
    (microsoft.public.access.queries)
  • Re: Year Only as Query Parameter
    ... >> enter the desired year they want matching records for. ... >> query? ... Prev by Date: ...
    (microsoft.public.access.queries)