Using Now() in a Query

[Paula]

I'm programming a query that will pop-up an alert to the
user that lets them know that certain tasks are due in 7
days. So, when they set up a due date in the form, this
query will run each time the form is opened and check for
7 day alerts, as I'm calling them. However, the query is
looking for EXACTLY 7 days and I'd really like it to bring
up the alert every day until the project is overdue. The
query currently reads, Between Now()+6 and Now()+7. To
try to fix the problem, I've reduced the first Now to +1
and then +0, but it didn't work. Does anybody have any
ideas?

Paula

 

[Phobos]

Between Now() and Now()+7

Should work, what exactly do you mean when you say "...it didn't work"?

P

 

[Ken Snell]

Now includes the time with the date. This means that you can "miss" some
records because the time components of their values don't fall into your
query range.

Assuming that all you want to use is the Date, use Date().