1 2 3 4 5 6
| SELECT T_PUNCH.PK_ID_PUNCH, T_PUNCH.F_DATE_TRAVAIL, T_PUNCH.F_EMPLOYE,
T_PUNCH.F_CODE_PROJET, T_PUNCH.F_TEMPS_TRAVAIL, T_PUNCH.FK_ID_CATEGORIE_TAUX,
DLookUp("F_MONTANT_TAUX", "T_TAUX", "F_DATE_ENTREE_EN_VIGUEUR<=#" & T_PUNCH.F_DATE_TRAVAIL & "#" & " AND F_DATE_FIN>=#" & T_PUNCH.F_DATE_TRAVAIL & "#" & " AND FK_ID_CATEGORIE_TAUX=" & T_PUNCH.FK_ID_CATEGORIE_TAUX) AS MontantTaux,
[MontantTaux]*[F_TEMPS_TRAVAIL] AS Total
FROM T_PUNCH
ORDER BY T_PUNCH.F_DATE_TRAVAIL, T_PUNCH.FK_ID_CATEGORIE_TAUX; |
Partager