Calculate Efficiency

[D Willett]

( Feels strange only me posting problems !! )

I have a query returning efficiency.
The calculation is Time Given divided by Time Taken which should return efficiency.
With the following query, I'm getting the wrong results in the TotEff column.
Working down the columns, the efficiency should be:

1.315....etc
0.977....
1.15 ....
etc

SELECT qryLabourTransaction.Name, Sum(qryLabourTransaction.ALL_HRS) AS SumOfALL_HRS, Sum(qryLabourTransaction.TAK_HRS) AS SumOfTAK_HRS, Sum([ALL_HRS]/[TAK_HRS]) AS TotEff
FROM qryLabourTransaction
GROUP BY qryLabourTransaction.Name;

Image1.PNG

[Wendell]

Your expression Sum([ALL_HRS]/[TAK_HRS]) AS TotEff
should be
SumOfAll_HR/sumOfTAK_HR as TotEff
You may or may not be able to do that in the same query - make sure it is at the end and set the Group By to Expression. If that doesn't work, create a select query based on the Group By query and put the Expression there.

[HansV]

Alternatively, change

Sum([ALL_HRS]/[TAK_HRS]) AS TotEff

to

Sum([ALL_HRS])/Sum([TAK_HRS]) AS TotEff

[D Willett]

How did I miss that ????

Thanks Guys.