Query all records within next 40 days

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

Guest

Hello,
I am using Access 2000 and I want to query a
table that has many fields including a date field.
The query that I need your help with needs to be
able to query all records that fall within the next 40
days. I am trying to get the following to work:
<= Date() >40

Is this the way to go about it? Or how would you write it?

Your help is greatly appreciated.

Iram/mcp
 
Hello,
I am using Access 2000 and I want to query a
table that has many fields including a date field.
The query that I need your help with needs to be
able to query all records that fall within the next 40
days. I am trying to get the following to work:
<= Date() >40

Is this the way to go about it? Or how would you write it?

Your help is greatly appreciated.

Iram/mcp
Click to expand...

As criteria for the date field use:

Between Date() and Date()+40
 
Back
Top