1 2 3
| SELECT plannings.PlanClé, plannings.PlanLundi AS Lundi, plannings.PlanProduit AS Produit, plannings.PlanHDC AS HDC, plannings.PlanHFC AS HFC, plannings.PlanCours AS Cours, plannings.PlanLieu AS Lieu, plannings.PlanProf AS Prof
FROM plannings
WHERE (((plannings.PlanLundi)=[Forms]![SaisiePlannings]![txtLundi]) AND ((plannings.PlanProduit) Like [Forms]![SaisiePlannings]![txtProduit]) AND ((plannings.PlanHDC)>=TimeSerial([Forms]![SaisiePlannings]![txtHHDC],[Forms]![SaisiePlannings]![txtMMDC],0)) AND ((plannings.PlanHFC)<=TimeSerial([Forms]![SaisiePlannings]![txtHHFC],[Forms]![SaisiePlannings]![txtMMFC],0))); |
Partager