1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT SoldeH.Période, Personnel.PerTXT, Sum(SoldeH.Nombre) AS Total, CInt(DateDiff("YYYY",[Personnel]![Né(e) le],CDate('30' & '.' & Right([Personnel]![Période],2) & '.' & Left([Personnel]![Période],4)),0,0)) AS Age
FROM Personnel INNER JOIN SoldeH ON (Personnel.Mat = SoldeH.Mat) AND (Personnel.Période = SoldeH.Période)
WHERE (((SoldeH.CatTps)<>99))
GROUP BY SoldeH.Période,Personnel.PerTXT, CInt(DateDiff("YYYY",[Personnel]![Né(e) le],CDate('30' & '.' & Right([Personnel]![Période],2) & '.' & Left([Personnel]![Période],4)),0,0));
UNION
SELECT Personnel.Période, Personnel.PerTXT, [Nombre]*8 AS Total, CInt(DateDiff("YYYY",[Personnel]![Né(e) le],CDate('30' & '.' & Right([Personnel]![Période],2) & '.' & Left([Personnel]![Période],4)),0,0)) AS Age
FROM Personnel INNER JOIN SoldeH ON (Personnel.Période = SoldeH.Période) AND (Personnel.Mat = SoldeH.Mat)
WHERE (((SoldeH.CatTps)=99))
GROUP BY Personnel.Période, Personnel.PerTXT, [Nombre]*8, CInt(DateDiff("YYYY",[Personnel]![Né(e) le],CDate('30' & '.' & Right([Personnel]![Période],2) & '.' & Left([Personnel]![Période],4)),0,0)), Personnel.Mat; |
Partager