1 2 3 4 5
| SELECT Usagers.Sexe, Switch([age]<18,"moins de 18 ans",[age] Between 18 And 20,"entre 18 et 20 ans",[age] Between 21 And 30,"entre 21 et 30 ans",[age] Between 31 And 40,"entre 31 et 40 ans",[age] Between 41 And 50,"entre 41 et 50 ans",[age] Between 51 And 60,"entre 51 et 60 ans",[age] Between 61 And 70,"entre 61 et 70 ans",[age] Between 71 And 80,"entre 71 et 80 ans",[age] Between 81 And 90,"entre 81 et 90 ans",[age] Between 91 And 100,"entre 91 et 100 ans",[age]>100,"101 ans et plus") AS trancheAge, Count(Courses.[N° Usager]) AS NbrParTranche
FROM [Age Usagers Fonction Usagers Présent] INNER JOIN (Usagers INNER JOIN ([Stat 091 Courses Ponctuelles Modif Criteres Recherche Annee] INNER JOIN Courses ON [Stat 091 Courses Ponctuelles Modif Criteres Recherche Annee].[N° Course] = Courses.[N° Course]) ON Usagers.[N° Usager] = Courses.[N° Usager]) ON [Age Usagers Fonction Usagers Présent].[N° Usager] = Usagers.[N° Usager]
WHERE (((Courses.[Date de la course]) Is Not Null))
GROUP BY Usagers.Sexe, Switch([age]<18,"moins de 18 ans",[age] Between 18 And 20,"entre 18 et 20 ans",[age] Between 21 And 30,"entre 21 et 30 ans",[age] Between 31 And 40,"entre 31 et 40 ans",[age] Between 41 And 50,"entre 41 et 50 ans",[age] Between 51 And 60,"entre 51 et 60 ans",[age] Between 61 And 70,"entre 61 et 70 ans",[age] Between 71 And 80,"entre 71 et 80 ans",[age] Between 81 And 90,"entre 81 et 90 ans",[age] Between 91 And 100,"entre 91 et 100 ans",[age]>100,"101 ans et plus")
ORDER BY Usagers.Sexe, Switch([age]<18,"moins de 18 ans",[age] Between 18 And 20,"entre 18 et 20 ans",[age] Between 21 And 30,"entre 21 et 30 ans",[age] Between 31 And 40,"entre 31 et 40 ans",[age] Between 41 And 50,"entre 41 et 50 ans",[age] Between 51 And 60,"entre 51 et 60 ans",[age] Between 61 And 70,"entre 61 et 70 ans",[age] Between 71 And 80,"entre 71 et 80 ans",[age] Between 81 And 90,"entre 81 et 90 ans",[age] Between 91 And 100,"entre 91 et 100 ans",[age]>100,"101 ans et plus"); |
Partager