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())
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Monthly data based on dates 2
Training schedule -need qry to return all employees for that month 1
Including form controls as fields in a query 5
Lookup in a query 1
Nz function not showing all records 2
How to count records w/o counting duplicates by week, month, or ye 4
RE: You tried to execute a query that does not include the specified e 0
Cross tab query solution 4

Back
Top