date query

  • Thread starter Thread starter Tim via AccessMonster.com
  • Start date 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.
 
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())
 
Back
Top