+ 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)

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