1 2 3
| SELECT tblPersonnel.Nom, tblPersonnel.DateNaissance, Format(DateDiff("y",[DateNaissance],Date()),"yy") AS AgeN, Format(DateDiff("y",[DateNaissance],Date()),"yy")+3 AS AgeN3, Format(DateDiff("y",[DateEntree],Date()),"yy") AS AnciennetéN, Format(DateDiff("y",[DateEntree],Date()),"yy")+3 AS AnciennetéN3, tblPersonnel.Sexe, IIf([AgeN]<=20,"- de 21 ans",IIf([AgeN]>20 And [AgeN]<26,"21 à 25 ans",IIf([AgeN]>25 And [AgeN]<32,"26 à 31 ans",IIf([AgeN]>31 And [AgeN]<36,"32 à 35 ans",IIf([AgeN]>35 And [AgeN]<41,"36 à 40 ans",IIf([AgeN]>40 And [AgeN]<46,"41 à 45 ans",IIf([AgeN]>45 And [AgeN]<51,"46 à 50 ans",IIf([AgeN]>50 And [AgeN]<56,"51 à 55 ans",IIf([AgeN]>54,"Plus de 55 ans"))))))))) AS Tranche, tblPersonnel.DateEntree, tblPersonnel.DateSortie
FROM tblPersonnel
WHERE (((tblPersonnel.DateEntree)<#1/1/2013#) AND ((tblPersonnel.DateSortie) Is Null)) OR (((tblPersonnel.DateEntree)<#1/1/2013#) AND ((tblPersonnel.DateSortie)>#12/31/2012#)); |
Partager