Query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a query that basically looks at the Date field and if the
date is older than 10 days those records will be returned.

Can anyone assist with the way I need to write this in the Criteria grid. I
am assuming it is some type of If query.

Thanks
Kris
 
kharrison said:
I need to write a query that basically looks at the Date field and if the
date is older than 10 days those records will be returned.

Can anyone assist with the way I need to write this in the Criteria grid. I
am assuming it is some type of If query.
Click to expand...

< Date() - 10
 
Back
Top