Well here I go again. Biting off more than my brain can handle. I have a
report that shows all of our machines in our plant. Im tracking both machine
down time (the time the machine is broken) and Plant Down Time (the time the
machine is broken that hampers production) I have a form that we use to
gather all pertinent information such as the date, time notified of
malfunction etc€¦

I have a query that well, queries the data so I can view what is happening
each month. That works great. Now to the meat and potatoes€¦ I calculate down
times by using:
Minutes: DateDiff("n", [Time Notified], [Time Returned to Service])
In my query (Time Notified is when the machine goes down and Time Returned
to Service is when its working again), this works fine. In my report I
simply use =Sum([Minutes]) in a control box to get the total machine down
time.

A little back tracking now; on my form (the one that fills out the data in
my table) the technician uses a check box to signify if the machine down time
also results in €œPlant Down Time€�.

Now in my query everything for that month shows up. Lets say I have 40
entries that result in 1,000 minutes of down time. But, 5 of those entries
resulted in Plant Down Time for a total of 100 minutes (5 check boxes are
checked in the table of the query).

How do I get those 5 Plant Down Time entries to show a Sum of 100 minutes in
my report?

The report should show something like this:

Total Machine Down Time for the Month: 1000

Total Plant Down Time for the Month: 100

But I dont know how to make the query only sum the result of the 5 Plant
Down Time check boxes.

I can make another query to just show the 5 check boxes and there minute
results but I do not know how to make that query usable on my form that is
already based on the first query.

Any help would be greatly appreciated.

--
Jeff G
Maintenance Tech
Milgard Tempering

How does your table store whether or not the box was checked? Do you put True
or False into a column? or is it still a checkbox?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jeff G" wrote:

Well here I go again. Biting off more than my brain can handle. I have a
report that shows all of our machines in our plant. Im tracking both machine
down time (the time the machine is broken) and Plant Down Time (the time the
machine is broken that hampers production) I have a form that we use to
gather all pertinent information such as the date, time notified of
malfunction etc€¦

I have a query that well, queries the data so I can view what is happening
each month. That works great. Now to the meat and potatoes€¦ I calculate down
times by using:
Minutes: DateDiff("n", [Time Notified], [Time Returned to Service])
In my query (Time Notified is when the machine goes down and Time Returned
to Service is when its working again), this works fine. In my report I
simply use =Sum([Minutes]) in a control box to get the total machine down
time.

A little back tracking now; on my form (the one that fills out the data in
my table) the technician uses a check box to signify if the machine down time
also results in €œPlant Down Time€�.

Now in my query everything for that month shows up. Lets say I have 40
entries that result in 1,000 minutes of down time. But, 5 of those entries
resulted in Plant Down Time for a total of 100 minutes (5 check boxes are
checked in the table of the query).

How do I get those 5 Plant Down Time entries to show a Sum of 100 minutes in
my report?

The report should show something like this:

Total Machine Down Time for the Month: 1000

Total Plant Down Time for the Month: 100

But I dont know how to make the query only sum the result of the 5 Plant
Down Time check boxes.

I can make another query to just show the 5 check boxes and there minute
results but I do not know how to make that query usable on my form that is
already based on the first query.

Any help would be greatly appreciated.

--
Jeff G
Maintenance Tech
Milgard Tempering