Results 1 to 2 of 2
  1. #1
    davidmdonaldson is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    1

    Query that results in a list of employees that DON'T have specific training.

    I am using Access to keep track of employee records. One the records in called "Pre-Job Safety Orientation".

    I can produce a query to show me the list of people who HAVE the training. Currently, this produces a list of 123 employees who have the training.

    I would like to produce a list of people who DO NOT have this training. This list would therefore produce a result of 25 people as we currently have 148 on staff.



    It is a painful process digging through to find out who we need to get into training.

    Can anyone please offer any advice?

    thank you in advance for your time...

    David

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Research access's Unmatched query in the Help.

    Research LEFT JOIN
    see http://www.w3schools.com/sql/sql_join_left.asp

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

Similar Threads

  1. staff training data base, training
    By SAJAN in forum Forms
    Replies: 1
    Last Post: 09-22-2012, 05:09 AM
  2. Replies: 1
    Last Post: 06-15-2012, 05:51 PM
  3. Training Database Query Help
    By cjb1317 in forum Queries
    Replies: 6
    Last Post: 10-05-2011, 09:43 AM
  4. Replies: 2
    Last Post: 12-29-2010, 02:05 PM
  5. Add Multiple Employees to a Training
    By Voltzwagon in forum Forms
    Replies: 1
    Last Post: 01-29-2010, 10:53 AM

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