Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: Or, more than once not working

    Simple expression, in a querry, in criteria I am using

    <> 0 Or 5 Or 10 Or 20

    these numbers in my database represent discount values and I am trying to exclude the above values to see the "exceptions". It works fine if I use just one i.e.

    <> 0

    but when I add the or and other numbers it fails completly and the end result I see all the numbers I am trying to exclude. What am I doing wrong?

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    That should be:
    Code:
    <>0 And <>5 And <>10 And <>20
    Alternatively, you can use:
    Code:
    Not In (0,5,10,20)

  3. #3
    Join Date
    Mar 2004
    Posts
    56
    Ahhh, thank you kindly

Posting Permissions

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