Previous Dates

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
< Date( ) + 1 AND >= Date( ) - 2


should do, in the grid., as criteria.



Vanderghast, Access MVP
 
Back
Top