completion - transformed Query always gives 100%

Hello all,



This works:

Code:

---

SELECT sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Calcul

FROM Q_Defects

WHERE (Q_Defects.dAreaFK)=[Forms]![F_MainMenu].[cboStatsArea];

---

This doesn't, can't find out why...

Code:

---

TRANSFORM nz(sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100,0) AS Completion

SELECT sum(iif(dDateFound is null,0,1)) AS [Found], sum(iif(dDateClosed is null,0,1)) AS Fixed, sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Compl

FROM Q_Defects

WHERE (dAreaFK=Forms!F_MainMenu.cboStatsArea

OR Forms!F_MainMenu!cboStatsArea IS NULL)

AND (dShiftFK=Forms!F_MainMenu.cboStatsShift

OR Forms!F_MainMenu!cboStatsShift IS NULL

AND month(dDateClosed)=month(Date()))

GROUP BY month([dDateClosed])

PIVOT month([dDateClosed])

IN (1,2,3,4,5,6,7,8,9,10,11,12);

---

Thanks :)

completion - transformed Query always gives 100%