Code:
SELECT Tbl_Client.COD, Tbl_Soumission.No_Job, Tbl_Soumission.No_Client, Tbl_Client.Nom, Tbl_Client.Telephone, Tbl_Production.Date_Livraison_Debut
FROM (Tbl_Client INNER JOIN Tbl_Soumission ON Tbl_Client.No_Client = Tbl_Soumission.No_Client) INNER JOIN Tbl_Production ON Tbl_Soumission.No_Job_auto = Tbl_Production.No_Soumission_Auto
WHERE (((Tbl_Client.COD)=Yes) AND (((Tbl_Production.Date_Livraison_Debut)<Now()
And (Tbl_Production.Date_Livraison_Debut)>Now()-5)
Or ((Tbl_Production.Date_Livraison_Debut)>Now()
And (Tbl_Production.Date_Livraison_Debut)<Now()+7)));
sorry those field name are in french but the search field is the -5 +7 and I would want to be able to change the -5 +7 in a form or something