Sorting Problem

[Midland]

I have data that is collected by job, so the basic table and query are sorted
by Job ID, Jobdate, Work Center, and Shift in my primary query. Downtime data
is also collected by day, so I have a totals query that gathers that
information. I have to combine the two to make a report, so I need to create
a query/report that uses these fields from [InQry]: [ID] - [WC] - [Jobdate]
- [Shift]

[DayDTQry] is "grouped by" the last three fields, but I wish to add to every
record of the final report three summed fields from this query: [SumofRun] -
[SumofJobDT] - [SumofJobCDT] and add in a calculated field, [Uptime], derived
from them.

Since there can be more than one job each shift, the sums can be repeated on
the report. What criteria/link can I use to use to attach the correct sums
to each record of the report?

 

[Klatuu]

Rather than performing the calculation in the report, I suggest you do so in
the query. That way you will get one sum for each row in the query and it
will execute the report faster. It is always better to do a calculation in
the query when you can.