1 2 3 4 5 6 7 8 9
| AlerteBientot :
SELECT tbl_Fiches.RefLivre, tbl_Fiches.Livre, tbl_Fiches.Debut, tbl_Fiches.Retour, DateAdd("ww",4,[Debut])-Date() AS Difference
FROM tbl_Fiches
WHERE (((tbl_Fiches.Debut)>=#3/1/2024#) AND ((tbl_Fiches.Retour) Is Null) AND ((DateAdd("ww",4,[Debut])-Date()) Between 0 And 7));
AlerteRetard
SELECT tbl_Fiches.RefLivre, tbl_Fiches.Livre, tbl_Fiches.Debut, tbl_Fiches.Retour, DateAdd("ww",4,[Debut]) AS DateEcheance
FROM tbl_Fiches
WHERE (((tbl_Fiches.Debut)>=#3/1/2024#) AND ((tbl_Fiches.Retour) Is Null) AND ((DateAdd("ww",4,[Debut]))<=Now())); |
Partager