>Fobio,

?

Convert this ?
>CAST(SUM(IIF(result="Fail",1,0)) AS I) Fail

SUM(CAST(result="Fail" AS I)) Fail

>please convert this line of code as
>TRANSFORM(roun((SUM(tobt)/SUM(tmax))*100,2),"##.##") AS PERCENTAGEu,;
> str((SUM(tobt)/SUM(tmax))*100,4,2) AS PERCENTAGEi;

post the your current SELECT.