Previous Dates

[Peter]

Hi all, i am ashamed to admit that i can not figure this one out..

In one table i have the DateCreated field. In my query i want to display all
records created today, Date() and during the previous two days. If today is
Thursday i also want to see the records created Tuesday and Wednesday and
today..

I am trying this -2<!>=Date() but it fails..

Any ideas?

Thanks!

 

[vanderghast]

< Date( ) + 1 AND >= Date( ) - 2


should do, in the grid., as criteria.



Vanderghast, Access MVP

 

[Peter]

Thank you very much! Indeed it works perfect!

< Date( ) + 1 AND >= Date( ) - 2


should do, in the grid., as criteria.



Vanderghast, Access MVP