Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query to compare two fields (2000)

    I want to run a query where I compare two fields and I only want the records where the two fields are different. Is this possible and if so, how would I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query to compare two fields (2000)

    See the attached screenshot. There are 3 criteria lines: one for the case that both fields are filled, and not equal, and one each for the case that one field is empty and the other isn't.
    Attached Images Attached Images

Posting Permissions

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