Query criteria

K

kharrison

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
 
R

Rick Brandt

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
 
Top