Query 40 days and more: Date()

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

Guest

Hello,
I am running Access 2000.
I would like to create a query in my date field that will show
all records that are more than 45 days old.
In other words if today was 9-1-04 I would like to see
all records that are about 7-15-04 and older.

Your help is greatly appreciated,
Iram/mcp
 
-----Original Message-----
Hello,
I am running Access 2000.
I would like to create a query in my date field that will show
all records that are more than 45 days old.
In other words if today was 9-1-04 I would like to see
all records that are about 7-15-04 and older.

Your help is greatly appreciated,
Iram/mcp

.
Click to expand...

In the criteria line of your query, under the date field,
use >7/15/04
This should give you only dates "greater than" 7/15/04.
If you want to include the date you're entering, use
=7/15/04. This will give you dates "greater than or
Click to expand...
equal to" 7/15/04.

I hope that helps!
Joan
 
-----Original Message-----
will

In the criteria line of your query, under the date field,
use >7/15/04
This should give you only dates "greater than" 7/15/04.
If you want to include the date you're entering, use
equal to" 7/15/04.

I hope that helps!
Joan

.
Click to expand...

I just realized that you probably don't want to enter a
new date every time you do the query - if you're always
interested in records that are more than 45 days old, you
can use the following in your date criteria:
<=Now()-45
That will give you dates that are "less than or equal to"
now (today) minus 45 days. In other words, dates that are
45 days old or older.

That may help more :)
Joan
 
Back
Top