Date Calc/Criteria

I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following date
criteria:

Now()
Now() but only 10 days into the future

Thanks in advance!
Anthony

Do you mean this criteria:

Now() Or Now()+10

Anthony Viscomi wrote:
I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following date
criteria:

Now()
Now() but only 10 days into the future

Thanks in advance!
Anthony

--
Message posted via http://www.accessmonster.com

Actually I mean this:

Now() Or =Now()+10

"kingston via AccessMonster.com" u27511@uwe wrote in message
news:6a131be27514d@uwe...
Do you mean this criteria:

Now() Or Now()+10

Anthony Viscomi wrote:
I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following
date
criteria:

Now()
Now() but only 10 days into the future

Thanks in advance!
Anthony

--
Message posted via http://www.accessmonster.com

I had a "Mental Breakdown"; all I needed was:
=Now()+10
"kingston via AccessMonster.com" u27511@uwe wrote in message
news:6a131be27514d@uwe...
Do you mean this criteria:

Now() Or Now()+10

Anthony Viscomi wrote:
I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following
date
criteria:

Now()
Now() but only 10 days into the future

Thanks in advance!
Anthony

--
Message posted via http://www.accessmonster.com

In the query, on one criteria line enter Now() and on another criteria line
enter Now()+10.

Anthony Viscomi wrote:
Actually I mean this:

Now() Or =Now()+10

Do you mean this criteria:

[quoted text clipped - 10 lines]
Thanks in advance!
Anthony

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200611/1

Be careful using Now() in a case like this. You may pick up records you
don't want or miss records you do want. Now contains time values, so that
the times are compares as well as the date. That will affect how the records
are returned. The same is true if your date field contains times.

I suggest using Date() rather than Now() unless you want to filter by time.



"Anthony Viscomi" wrote:

I had a "Mental Breakdown"; all I needed was:
=Now()+10
"kingston via AccessMonster.com" u27511@uwe wrote in message
news:6a131be27514d@uwe...
Do you mean this criteria:

Now() Or Now()+10

Anthony Viscomi wrote:
I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following
date
criteria:

Now()
Now() but only 10 days into the future

Thanks in advance!
Anthony

--
Message posted via http://www.accessmonster.com