date query

  • Thread starter Tim via AccessMonster.com
  • Start date
T

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.
 
M

Marshall Barton

Tim said:
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.
Click to expand...


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