Query for filter

[Rashid]

Ok sir
I have created a laundry software
I want a query in which i can trace (sort) orders which are to be deliverd after 3 Days
So i can prepare them before expected Date.

 

[arnelgp]

add criteria to your query:

select * from table1 where [delivery date] =( Date() + 3);"

or

select * from table1 where [delivery date] =DateAdd("d", 3, Date())

 

[Rashid]

Thank lot