1 2 3 4
| SELECT [Pourcentages écarts].ENSEIGNE, [Pourcentages écarts].CLIENT, [Pourcentages écarts].VILLE, [Pourcentages écarts].Réseau, IIf([Pourcentages écarts].[L1_Expr1001]="CNP","CNP","") AS L1, IIf([Pourcentages écarts].[M1_Expr1001]="CNP","CNP","") AS M1, IIf([Pourcentages écarts].[Me1_Expr1001]="CNP","CNP","") AS Me1, IIf([Pourcentages écarts].[J1_Expr1001]="CNP","CNP","") AS J1, IIf([Pourcentages écarts].[V1_Expr1001]="CNP","CNP","") AS V1, IIf([Pourcentages écarts].[S1_Expr1001]="CNP","CNP","") AS S1, IIf([Pourcentages écarts].[D1_Expr1001]="CNP","CNP","") AS D1, IIf([Pourcentages écarts].[L2_Expr1001]="CNP","CNP","") AS L2, IIf([Pourcentages écarts].[M2_Expr1001]="CNP","CNP","") AS M2, IIf([Pourcentages écarts].[Me2_Expr1001]="CNP","CNP","") AS Me2, IIf([Pourcentages écarts].[J2_Expr1001]="CNP","CNP","") AS J2, IIf([Pourcentages écarts].[V2_Expr1001]="CNP","CNP","") AS V2, IIf([Pourcentages écarts].[S2_Expr1001]="CNP","CNP","") AS S2, IIf([Pourcentages écarts].[D2_Expr1001]="CNP","CNP","") AS D2, IIf([Pourcentages écarts].[L3_Expr1001]="CNP","CNP","") AS L3, IIf([Pourcentages écarts].[M3_Expr1001]="CNP","CNP","") AS M3, IIf([Pourcentages écarts].[Me3_Expr1001]="CNP","CNP","") AS Me3, IIf([Pourcentages écarts].[J3_Expr1001]="CNP","CNP","") AS J3, IIf([Pourcentages écarts].[V3_Expr1001]="CNP","CNP","") AS V3, IIf([Pourcentages écarts].[S3_Expr1001]="CNP","CNP","") AS S3, IIf([Pourcentages écarts].[D3_Expr1001]="CNP","CNP","") AS D3, [Pourcentages écarts].OK, [Pourcentages écarts].NC, [Pourcentages écarts].CNP
FROM [Pourcentages écarts]
WHERE ((([Pourcentages écarts].CNP) Is Not Null))
ORDER BY [Pourcentages écarts].CNP DESC; |
Partager