1 2
| SELECT Comparaison.LIEN, IIf([L1_Expr1001]="OK",1,' ') AS [écart L1], IIf([M1_Expr1001]="OK",1,' ') AS [écart M1], IIf([Me1_Expr1001]="OK",1,' ') AS [écart Me1], IIf([J1_Expr1001]="OK",1,' ') AS [écart J1], IIf([V1_Expr1001]="OK",1,' ') AS [écart V1], IIf([S1_Expr1001]="OK",1,' ') AS [écart S1], IIf([D1_Expr1001]="OK",1,' ') AS [écart D1], IIf([L2_Expr1001]="OK",1,' ') AS [écart L2], IIf([M2_Expr1001]="OK",1,' ') AS [écart M2], IIf([Me2_Expr1001]="OK",1,' ') AS [écart Me2], IIf([J2_Expr1001]="OK",1,' ') AS [écart J2], IIf([V2_Expr1001]="OK",1,' ') AS [écart V2], IIf([S2_Expr1001]="OK",1,' ') AS [écart S2], IIf([D2_Expr1001]="OK",1,' ') AS [écart D2]
FROM Comparaison; |
Partager