1 2 3
| SELECT tblPVE.[CODE CENTRE], Switch(Left([MARQUE DU FABRICANT],2)="WD","Mercedes",Left([MARQUE DU FABRICANT],2)="VF","Renault",Left([MARQUE DU FABRICANT],2) In ("SJ","SH","MD","JN","JH"),"Nissan",Left([MARQUE DU FABRICANT],2)="3H","Honda",True,"Inconnu :" & Left([MARQUE DU FABRICANT],2)) AS OEM, Count(tblPVE.CHASSIS) AS [Nb VIN]
FROM tblPVE
GROUP BY tblPVE.[CODE CENTRE], Switch(Left([MARQUE DU FABRICANT],2)="WD","Mercedes",Left([MARQUE DU FABRICANT],2)="VF","Renault",Left([MARQUE DU FABRICANT],2) In ("SJ","SH","MD","JN","JH"),"Nissan",Left([MARQUE DU FABRICANT],2)="3H","Honda",True,"Inconnu :" & Left([MARQUE DU FABRICANT],2)); |
Partager