+ Reply to Thread
Results 1 to 5 of 5

Compare two tables and find only unmatching/remaining data

  1. #1
    Registered User
    Join Date
    07-11-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    22

    Compare two tables and find only unmatching/remaining data

    Dear expert

    I am a very beginner by using access, and my english is not very good, sorry about that.

    I have a problem when i create the Queries. There are two table called A and B:

    Table A:
    1 2 3 4 5 6 7
    -----------------------------------------------
    50 92 35 50 50 20 12
    88 77 65 94 50 28 22
    87 77 65 94 50 28 22

    Table B:
    id date 1 2 3 4 5 6 7
    ---------------------------------------------------------------------------------
    12366 08/12/2016 87 77 65 94 50 28 22

    i want to find out the reaming tabla A exlcute/out the data of Table B:

    Finally result:
    1 2 3 4 5 6 7
    -----------------------------------------------
    50 92 35 50 50 20 12
    88 77 65 94 50 28 22

    i hope you can understand what i mean. Thank you very much, and i upload the access to you

    Thanks again
    Isaac
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Compare two tables and find only unmatching/remaining data

    If,and I mean if, the entire row is the same in A and B. (explain later)
    Then you can join the 2 tables on tableA.1 to tableB.3
    This will show your results that match.
    If you want to know what's missing , use the query and make it an outer join. This will
    Show what's missing.

    Now, in my 1st statement, this method will fail if the fields are random.
    Table b has 88,77,65,94 ....JUST like in table A.
    If this can be random,say 88,45,22,99...then this method will fail.

  3. #3
    Registered User
    Join Date
    07-11-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Compare two tables and find only unmatching/remaining data

    I can change the entire row is the same in A and B.

    But Table A will enter lots of data, the data in Table B should less than Table A.

    If all data in Table B equal to part of the data in Table A then leave it/remove it, the remaining data in Table A is used to next step, but dont know how to do.

  4. #4
    Registered User
    Join Date
    07-11-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Compare two tables and find only unmatching/remaining data

    Table A
    1.jpg

    Table B
    2.jpg

    Final result
    2 3 4 5 6 7 9

    but dont know how to do.

  5. #5
    Registered User
    Join Date
    07-11-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Compare two tables and find only unmatching/remaining data

    Table A
    Attachment 492703

    Table B
    Attachment 492704

    Final result
    2 3 4 5 6 7 9

    but dont know how to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-18-2015, 05:19 PM
  2. compare tables data
    By ghassenfocus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 04:27 PM
  3. [SOLVED] Compare 2 Tables to find the PROFIT faster
    By harimin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-28-2013, 06:55 PM
  4. Compare two data tables
    By xpiamchris in forum Excel General
    Replies: 3
    Last Post: 03-24-2011, 11:32 PM
  5. Find data and delete remaining rows (For each loop)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2009, 11:45 AM
  6. Excel 2007 : How to compare data in two tables?
    By learner6 in forum Excel General
    Replies: 4
    Last Post: 04-05-2009, 12:59 AM
  7. filtering unmatching data
    By bearaman in forum Excel General
    Replies: 4
    Last Post: 03-21-2008, 10:23 AM

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