query to be able to query many dates

[Grooz13]

Ok i have a querry that filter some order we get here at work, and it filters order from yesterday to the next 5 days, always this. But I want to be able sometime to check for the next 10 days is it possible to do without having to change the querry like just do a querry with a changing +days?

[weekend00]

it will be much easier for us to give an answer if you post you query here.

[Grooz13]

 
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

[weekend00]

if you have 2 textboxes(e.g. day1, day2) in your form ("frmName), you can change the query to:


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()-forms("frmName") .day1)
Or ((Tbl_Production.Date_Livraison_Debut)>Now()
And (Tbl_Production.Date_Livraison_Debut)<Now()+forms("frmName") .day2)));

[Grooz13]

great idea, and if I want to display the form as a datasheet do I do the same thing ?

[weekend00]

I think so. just go head, if there is any question, come back here.

[Grooz13]

Thank you I adapted what you said to my situation and it works !

[weekend00]

That's wonderful!