1 2 3
| SELECT T_Planning.DateJour, T_Planning.DateJour, T_Planning.NumPlanning, T_Planning.Heure1MA, T_Planning.Heure2MA, T_Planning.Heure1AM, T_Planning.Heure2AM, T_Planning.HeureR1MA, T_Planning.HeureR2MA, T_Planning.HeureR1AM, T_Planning.HeureR2AM, T_Planning.PeriodeJour, T_Planning.NbHeuresSup, T_Planning.IdEmploye, T_Planning.Memo, T_Planning.Fonction, T_Planning.FonctionR, T_Planning.UserNameMaj, T_Planning.DateHeureMaj, T_Planning.Nbre_CP, T_Planning.Date_JF_Recup
FROM T_Planning, T_DateCP
WHERE (((T_Planning.DateJour)>=[T_DateCP]![DateDebutCP] And (T_Planning.DateJour)<=[T_DateCP]![DateFinCP]) AND (Not (Format(Date(),"ddd")="dim"))); |
Partager