1 2 3 4 5
|
SELECT T_Presence.NB, T_Personne.Nom, T_Personne.Prénom, T_Personne.[Date embauche], T_Personne.[Jours de Congés], T_Presence.DateD, T_Presence.DateF, T_Presence.CodeJ, T_Code.Intitulé, T_Presence.Motif, T_Presence.Durée, T_Presence.Compensation, T_Presence.Validation, Work_Days([DateD],[DateF]) AS Présence_Absence
FROM (T_Personne INNER JOIN T_Presence ON T_Personne.Matricule = T_Presence.NB) INNER JOIN T_Code ON T_Presence.CodeJ = T_Code.CodeJ
WHERE (((T_Presence.NB) Like "*" & [Forms]![F_Individuel]![NB] & "*") AND ((T_Presence.DateD) Between [Forms]![F_Individuel]![DateD] And [Forms]![F_Individuel]![DateF]) AND ((T_Presence.CodeJ)="C" Or (T_Presence.CodeJ)="F"))
ORDER BY T_Personne.Nom, T_Presence.DateD, T_Personne.Matricule; |
Partager