+ Reply to Thread
Results 1 to 2 of 2

Find unmatched records in Access

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    87

    Find unmatched records in Access

    So I have 2 tables in access. lets say table a and b.

    both tables have same fields (employee id, last name, first name, and account number).

    information in employee id, last name, and first name are the same.

    the one who is different is the account number.

    i would like to create a query that enables me to see those employees who have DIFFERENT account numbers in table a and b.

    example: if jack has account number 1000 in table a and account number 2000 in table b, i want to him in the query. but if he has account number 1000 in both table a and b (match), then i dont want him in the query.

    how do you achieve this? thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,858

    Re: Find unmatched records in Access

    Use the query wizard. It offers an unmatched query.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1