DateAdd

[brin]

I want to find some data in the past by using the date add function but i don't want to just use static numbers i.e >=DateAdd("d", -30, Date()). Is it possible to run the query then input the days required for the search?

 

[Mile-O]

You could just do this:

>=DateAdd("d", -[Enter Number Of Days], Date())

That way you'll be prompted to put the number of days in.

 

[brin]

I want to find some data in the past by using the date add function but i don't want to just use static numbers i.e >=DateAdd("d", -30, Date()). Is it possible to run the query then input the days required for the search?

Thank You Milo!