Hi,
I have a query which calculate the total hours per job. These hours are split in working hours and downtime.
But in case of only working hours I want the downtime hours filled with a "0" .
I found a couple of threads on this topic but can't figure out how to use the code correctly.
SQL:
SELECT QryStatusReport3a.JobNumber, First(QryStatusReport3a.SumOfHoursWorkedTotal) AS FirstOfSumOfHoursWorkedTotal, QryStatusReport3b.SumOfHoursWorkedTotal
FROM QryStatusReport3a INNER JOIN QryStatusReport3b ON QryStatusReport3a.JobNumber = QryStatusReport3b.JobNumber
GROUP BY QryStatusReport3a.JobNumber, QryStatusReport3b.SumOfHoursWorkedTotal;
I have a query which calculate the total hours per job. These hours are split in working hours and downtime.
But in case of only working hours I want the downtime hours filled with a "0" .
I found a couple of threads on this topic but can't figure out how to use the code correctly.
SQL:
SELECT QryStatusReport3a.JobNumber, First(QryStatusReport3a.SumOfHoursWorkedTotal) AS FirstOfSumOfHoursWorkedTotal, QryStatusReport3b.SumOfHoursWorkedTotal
FROM QryStatusReport3a INNER JOIN QryStatusReport3b ON QryStatusReport3a.JobNumber = QryStatusReport3b.JobNumber
GROUP BY QryStatusReport3a.JobNumber, QryStatusReport3b.SumOfHoursWorkedTotal;