Trying to display records that are 6 months old

  • Thread starter Thread starter bash
  • Start date Start date
B

bash

I have a database which lists employee details including there start dates.

I'm trying to produce a report/query which return employees that have been
with us for more than 6 months.

The database has a StartDate field where we have entered the date they
started with the company & this is the field i need to query.

Any help would be much appreciated.

Regards
Bash
 
In the Criteria row of your query, uner the StartDate field, try:
<= DateAdd("m", -6, Date())
 
Back
Top