Query all records within next 40 days

[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

 

[fredg]

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

As criteria for the date field use:

Between Date() and Date()+40