1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SELECT T_DemiRecirculation_Vrac.N°_Porte,
T_DemiRecirculation_Vrac.DESTINATION,
DCount("[Nbcolis]", "[T_DemiRecirculation_Vrac]",
"[N°_Porte]=63 ") As nbre_Colis_DR,FormatPercent(DCount("[Nbcolis]",
"[T_DemiRecirculation_Vrac]","[N°_Porte]=63 ")/DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]")) AS TauxColis,
DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]","[N°_Porte]=63 and [Ilot]='ilot 1'and [brin]='brin2'") AS nbre_Colis_DR_Ilot1,
DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]", "[N°_Porte]=63 and [Ilot]='ilot 2' and [brin]='brin1'") AS nbre_Colis_DR_Ilot2,
FormatPercent(DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]","[N°_Porte]=63 and [Ilot]='ilot 1'and [brin]='brin2'")/DCount("[Nbcolis]","
[T_DemiRecirculation_Vrac]","[N°_Porte]=63 ")) AS TauxColis_ilot1,
FormatPercent(DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]","[N°_Porte]=63 and [Ilot]='ilot 2' and [brin]='brin1'")/DCount("[Nbcolis]","[T_DemiRecirculation_Vrac]","[N°_Porte]=63 ")) AS TauxColis_ilot2
FROM T_DemiRecirculation_Vrac
GROUP BY T_DemiRecirculation_Vrac.N°_Porte,
T_DemiRecirculation_Vrac.DESTINATION
HAVING (((T_DemiRecirculation_Vrac.N°_Porte)=63)); |
Partager