Results 1 to 3 of 3
  1. #1
    da_coolest is offline Novice
    Windows 7 Access 2003
    Join Date
    Dec 2009
    Posts
    2

    Arrow employees who has been working for more than 10 years?

    I have created a database for employees which includes the "Name", and the "Hired date" and I want to make a query to show the names of the employees who has been working for more than 10 years for the company and also to show how long they have been working for the company.

    (I only use the graphical design view to make and edit queries and i have a very basic knowledge on access! )




    I need your help to understand how to make this query. thanks in advance!

  2. #2
    da_coolest is offline Novice
    Windows 7 Access 2003
    Join Date
    Dec 2009
    Posts
    2
    bump..............

  3. #3
    CGM3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Atlanta, GA
    Posts
    49
    Try this. Assuming the employee hire date is a field called HireDate included in your query, in the Criteria field of that column of the query design display (beneath the Show check box) enter:

    <=[Check Date]

    In the top row of an empty column of the query design display, enter:

    =(Now()-[EmployeeTable]![HireDate])/365

    When you execute the query, it will prompt you for Check Date; enter a date ten years in the past, and the query will return those employees whose hire date is on or before that date (in other words, been employed ten or more years) and their length of employment as a real number (such as 10.255 for about ten years and three months).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Multiple years
    By sammer021486 in forum Queries
    Replies: 3
    Last Post: 10-21-2009, 02:13 PM
  2. Sigh, having used Access in 5 years and stuck..
    By Access Denied in forum Access
    Replies: 3
    Last Post: 10-06-2009, 02:19 PM
  3. Why isn't this working?
    By adiecidue in forum Queries
    Replies: 4
    Last Post: 04-27-2009, 10:29 AM
  4. query date that is five years older than today
    By cpsummer in forum Queries
    Replies: 2
    Last Post: 09-26-2007, 02:31 PM
  5. Replies: 1
    Last Post: 03-15-2007, 03:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums