+ Reply to Thread
Results 1 to 2 of 2

Compare two tables and find records without matches

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

    Compare two tables and find records without matches

    Dear expert

    Can any expert help to create an access. I am a beginner of using access, hope you can help me.

    I would like to create two table, Table A and Table B

    Table A:

    N1: Number, no decimal palce
    N2: Number, no decimal palce
    N3: Number, no decimal palce
    N4: Number, no decimal palce
    N5: Number, no decimal palce

    Example
    N1, N2, N3, N4, N5, N6, N7
    1, 2, 3, 4, 5, 6, 7
    2, 2, 3, 4, 5, 6, 7

    Table B:
    Date: 1/11/2019
    remark: Text
    N1: Number, no decimal palce
    N2: Number, no decimal palce
    N3: Number, no decimal palce
    N4: Number, no decimal palce
    N5: Number, no decimal palce

    Example
    Date, Remark, N1, N2, N3, N4, N5, N6, N7
    1/11/2019, abc, 1, 2, 3, 4, 5, 6, 7
    2/11/2019, def, 2, 2, 3, 4, 5, 6, 8


    When running the queries, Compare two tables and find records without matches

    Result:
    N1, N2, N3, N4, N5, N6, N7
    2, 2, 3, 4, 5, 6, 7

    Use table B to find out the records without matches in Table A, many many data in table A.

    Sorrry for my poor english and thank for all expert help here. Thank you very much.
    Attached Files Attached Files
    Last edited by Isaacliu; 11-14-2019 at 10:56 PM.

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

    Re: Compare two tables and find records without matches

    Please help!!

+ 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. Find a value and check it matches and compare
    By khanaran in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2018, 11:15 AM
  2. Replies: 1
    Last Post: 07-07-2018, 02:52 AM
  3. [SOLVED] Compare two lists of words to find closest matches
    By elise.benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2015, 10:02 AM
  4. Replies: 4
    Last Post: 08-03-2015, 02:47 PM
  5. [SOLVED] Compare two sheets to find matches?
    By BlueMoonNJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2013, 04:16 PM
  6. compare data and find matches for particular cell value
    By ea223 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2013, 07:48 PM
  7. Replies: 1
    Last Post: 07-23-2012, 12:50 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