1 2
| SELECT r_liste_préf_2010.MOD_ID, IIf([Colo] Is Not Null,1,0) AS ColoBis, IIf([Colo blond] Is Not Null,1,0) AS ColoBlond, IIf([Colo ton sur ton] Is Not Null,1,0) AS ColoTonSurTon, IIf([Décolo] Is Not Null,1,0) AS DécoloBis, IIf([Dépilatoire MZ] Is Not Null,1,0) AS DépilMZ, IIf([Dépilatoire Senso] Is Not Null,1,0) AS DépilSenso, IIf([EV_CCS] Is Not Null,1,0) AS EVCCS, IIf([Sujets à pellicules] Is Not Null,1,0) AS SujetsPellicules, [ColoBis]+[ColoBlond]+[ColoTonSurTon]+[DécoloBis]+[DépilMZ]+[DépilSenso]+[EVCCS]+[SujetsPellicules] AS nbListes, [Colo] & [Colo blond] & [Colo ton sur ton] & [Décolo] & [EV_CCS] & [Sujets à pellicules] & [Dépilatoire MZ] & [Dépilatoire Senso] AS multiListe, [Colo] & "-" & [Colo blond] & "-" & [Colo ton sur ton] & "-" & [Décolo] & "-" & [Dépilatoire MZ] & "-" & [Dépilatoire Senso] & "-" & [EV_CCS] & "-" & [Sujets à pellicules] AS multiListe2
FROM r_liste_préf_2010; |
Partager