query for records from current date + plus ten days

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

Guest

Hi,

I want to run a query (for a report) that shows all the actions to be
completed in the next days. I have managed to get as far as filter all
records for those with action target dates from the current date, but can't
seem to limit it to the next ten days.

Please advise ona solution as I'm getting frustrated here
 
In the Criteria row under your date field in query design, try:
Between Date() and 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

Query the top top ten by category? 2
Top Ten Albums 10
automatic enter a date plus one day from the previous record 1
Excel Message box with days of month & date. 1
Date search query 0
Query/Reports Dates 3
Target Due date and countdown for working days 1
date query 4

Back
Top