date query

[Tim via AccessMonster.com]

I need to create a query that gives me everyone who has a start date that is
45 or more days old. The field that I am querying is Start Date and the
format is short date.

 

[John Spencer]

Field: StartDate
Criteria: <=Date()-45

 

[Marshall Barton]

I need to create a query that gives me everyone who has a start date that is
45 or more days old. The field that I am querying is Start Date and the
format is short date.

Create the query in the usual way and set the Criteria for
the StartDate field to <DateAdd("d", -45, Date())