Date Calc/Criteria

[Anthony Viscomi]

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

 

[kingston via AccessMonster.com]

Do you mean this criteria:

<Now() Or >Now()+10

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()

Thanks in advance!
Anthony

 

[Anthony Viscomi]

Actually I mean this:

<Now() Or =Now()+10

Do you mean this criteria:

<Now() Or >Now()+10

 

[Anthony Viscomi]

I had a "Mental Breakdown"; all I needed was:
<=Now()+10

 

[kingston via AccessMonster.com]

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

Actually I mean this:

<Now() Or =Now()+10

Do you mean this criteria:

[quoted text clipped - 10 lines]