1 2
| SELECT R_RegroupPar_IR.CodeIR, Round(IIf([Tot_Prev_Exec]<>0,[R_Prev_Exec_Croise].[1]/[Tot_Prev_Exec],0),2) AS Ex_P_S0, Round(IIf([Tot_Prev_Exec]<>0,[R_Prev_Exec_Croise].[2]/[Tot_Prev_Exec],0),2) AS Ex_P_S1, Round(IIf([Tot_Prev_Exec]<>0,[R_Prev_Exec_Croise].[3]/[Tot_Prev_Exec],0),2) AS Ex_P_S2, Round(IIf([Tot_Prev_Exec]<>0,[R_Prev_Exec_Croise].[4]/[Tot_Prev_Exec],0),2) AS Ex_P_S3, Round(IIf([Tot_Prev_Exec]<>0,[R_Prev_Exec_Croise].[5]/[Tot_Prev_Exec],0),2) AS Ex_P_S4, Round(IIf([Tot_Prev_Exec]<>0,[R_Real_Exec_Croise].[1]/[Tot_Prev_Exec],0),2) AS Ex_R_S0, Round(IIf([Tot_Prev_Exec]<>0,[R_Real_Exec_Croise].[2]/[Tot_Prev_Exec],0),2) AS Ex_R_S1, Round(IIf([Tot_Prev_Exec]<>0,[R_Real_Exec_Croise].[3]/[Tot_Prev_Exec],0),2) AS Ex_R_S2, Round(IIf([Tot_Prev_Exec]<>0,[R_Real_Exec_Croise].[4]/[Tot_Prev_Exec],0),2) AS Ex_R_S3, Round(IIf([Tot_Prev_Exec]<>0,[R_Real_Exec_Croise].[5]/[Tot_Prev_Exec],0),2) AS Ex_R_S4, Round(IIf([Tot_Prev_Valid]<>0,[R_Real_Valid_Croise].[1]/[Tot_Prev_Valid],0),2) AS Val_R_S0, Round(IIf([Tot_Prev_Valid]<>0,[R_Real_Valid_Croise].[2]/[Tot_Prev_Valid],0),2) AS Val_R_S1, Round(IIf([Tot_Prev_Valid]<>0,[R_Real_Valid_Croise].[3]/[Tot_Prev_Valid],0),2) AS Val_R_S2, Round(IIf([Tot_Prev_Valid]<>0,[R_Real_Valid_Croise].[4]/[Tot_Prev_Valid],0),2) AS Val_R_S3, Round(IIf([Tot_Prev_Valid]<>0,[R_Real_Valid_Croise].[5]/[Tot_Prev_Valid],0),2) AS Val_R_S4, Round(IIf([Tot_Prev_Valid]<>0,[R_Prev_Valid_Croise].[1]/[Tot_Prev_Valid],0),2) AS Val_P_S0, Round(IIf([Tot_Prev_Valid]<>0,[R_Prev_Valid_Croise].[2]/[Tot_Prev_Valid],0),2) AS Val_P_S1, Round(IIf([Tot_Prev_Valid]<>0,[R_Prev_Valid_Croise].[3]/[Tot_Prev_Valid],0),2) AS Val_P_S2, Round(IIf([Tot_Prev_Valid]<>0,[R_Prev_Valid_Croise].[4]/[Tot_Prev_Valid],0),2) AS Val_P_S3, Round(IIf([Tot_Prev_Valid]<>0,[R_Prev_Valid_Croise].[5]/[Tot_Prev_Valid],0),2) AS Val_P_S4
FROM (((R_RegroupPar_IR INNER JOIN R_Prev_Exec_Croise ON R_RegroupPar_IR.CodeIR = R_Prev_Exec_Croise.CodeIR) INNER JOIN R_Real_Exec_Croise ON R_RegroupPar_IR.CodeIR = R_Real_Exec_Croise.CodeIR) INNER JOIN R_Real_Valid_Croise ON R_RegroupPar_IR.CodeIR = R_Real_Valid_Croise.CodeIR) INNER JOIN R_Prev_Valid_Croise ON R_RegroupPar_IR.CodeIR = R_Prev_Valid_Croise.CodeIR; |
Partager