Results 1 to 2 of 2

Query to Extract new Employee and old employee

  1. #1
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    45

    Query to Extract new Employee and old employee


    I have two access tables. One is Table A, containing three employees. they are 001, 002 and 003. Table B contains 4 employees. They are 001 and 004 and 005. I need the new employee report, which I am expecting to see employee 004 and 005. I also need the old employee report in which I expect t see employee 002 and 003.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,768
    Note that Access has a built-in "Unmatched Query Wizard" which can help you to do this easily.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

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

Similar Threads

  1. Replies: 15
    Last Post: 05-12-2017, 04:09 AM
  2. Replies: 2
    Last Post: 05-09-2017, 04:12 PM
  3. Replies: 1
    Last Post: 04-14-2014, 11:44 AM
  4. Replies: 8
    Last Post: 06-06-2012, 12:28 PM
  5. Filtering employee id with query on a form
    By stylar in forum Queries
    Replies: 1
    Last Post: 04-23-2012, 06:01 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
  •  
Tech Forums: Microsoft Office Forums