Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

info on what does not match

Discussion in 'Information Technology' started by mark, Jul 28, 2006.

Tags:
  1. mark

    mark
    Expand Collapse
    Guest

    I'm looking for info on how to get results on what does NOT MATCH between two
    fields in two different tables. The field type are the same type (numbers).

    If I do a join, I only get what matches. I tried using "<>" and "NOT LIKE"
    but they want a value to work with. I want to compair two fields, if they do
    not match, display what did not match.

    I only want what does not match.

    I have spent about 5 hour searching through Access help and did not find
    anything.

    I'm known for operator error or I might be doing the search properly.

    HELP

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/com...-b2c7-ea314f1955a8&dg=microsoft.public.access
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    What does "NOT MATCH" mean?

    Do you have some common field between the two tables so that you know which
    row in Table A corresponds to which row in Table B and you strictly want to
    know whether Field 1 in Table A equals Field 2 in Table B, or is it
    something more complicated than that?

    Give some indication of what the two tables look like, some sample data and
    the expected results corresponding to your sample data.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "mark" <mark@discussions.microsoft.com> wrote in message
    news:8463F717-F866-4341-B2C7-EA314F1955A8@microsoft.com...
    > I'm looking for info on how to get results on what does NOT MATCH between
    > two
    > fields in two different tables. The field type are the same type
    > (numbers).
    >
    > If I do a join, I only get what matches. I tried using "<>" and "NOT LIKE"
    > but they want a value to work with. I want to compair two fields, if they
    > do
    > not match, display what did not match.
    >
    > I only want what does not match.
    >
    > I have spent about 5 hour searching through Access help and did not find
    > anything.
    >
    > I'm known for operator error or I might be doing the search properly.
    >
    > HELP
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow
    > this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/com...-b2c7-ea314f1955a8&dg=microsoft.public.access
     
  4. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    SELECT *
    FROM A
    WHERE A.NumberField Not In (SELECT B.NumberField FROM B);
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "mark" wrote:

    > I'm looking for info on how to get results on what does NOT MATCH between two
    > fields in two different tables. The field type are the same type (numbers).
    >
    > If I do a join, I only get what matches. I tried using "<>" and "NOT LIKE"
    > but they want a value to work with. I want to compair two fields, if they do
    > not match, display what did not match.
    >
    > I only want what does not match.
    >
    > I have spent about 5 hour searching through Access help and did not find
    > anything.
    >
    > I'm known for operator error or I might be doing the search properly.
    >
    > HELP
    >
     
  5. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Go to queries, click on new and then in the new query dialog, select 'find
    unmatched query wizard' (usually the last option in the list). Let the wizard
    take you through the steps.

    Delordson Kallon
    www.instantsoftwaretraining.com

    "mark" wrote:

    > I'm looking for info on how to get results on what does NOT MATCH between two
    > fields in two different tables. The field type are the same type (numbers).
    >
    > If I do a join, I only get what matches. I tried using "<>" and "NOT LIKE"
    > but they want a value to work with. I want to compair two fields, if they do
    > not match, display what did not match.
    >
    > I only want what does not match.
    >
    > I have spent about 5 hour searching through Access help and did not find
    > anything.
    >
    > I'm known for operator error or I might be doing the search properly.
    >
    > HELP
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/com...-b2c7-ea314f1955a8&dg=microsoft.public.access
     

Share This Page