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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Formatting date gives bad results in query 2
Use In() Expression as Query criteria with guts from Function 1
Use a function in the "Criteria" of a query? 3
Filtering Criteria Question 2
criteria on form 1
DateAdd Function 9
Parameter Query multiple criteria help 6

Back
Top