Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53

    Unanswered: A little assistance

    I know there is a simple answer to do this, but I am suffering from brain melt right now. I need to compare column E to column G and spit out the records that are different. Example in the table it has the name of a person and in Column E is the plan that we say the person is in and in Column G is the plan that our health insurance provider says they are in. I just then need to spit the whole record out and say E does not equal G.

    Thanks in advace.
    CAT :-D

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Select *
    FROM yourTable
    WHERE[E]<>[G]
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Or

    Select * FROM yourTable WHERE[E] Not in ([G])

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by hammbakka
    Or

    Select * FROM yourTable WHERE[E] Not in ([G])
    I wouldn't recommend that route. Insurance is wacky with their names. Eg in some of my dealings we saw: The Builders Group, The Builders Group of MN, Unified Insurance, Unified Insurance Brokers etc etc
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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