2 Replies Latest reply: May 15, 2014 9:55 AM by cardealers _ RSS

    My filter isn't filtering!?

    Amadea _

      Yes, I'm new. But I've used Monarch extensively in its DOS based first version.  Now, after a break I'm using version 5.something.

       

      Here's the question:  Why doesn't this filter work?

      (Title<>"SUSPENDED"  .And. ToDte="99/99/99") .Or. (Title<>"DIR STUDY" .And. ToDte="99/99/99")  .Or. (Title<>"CLASS AUDITING"  .And. ToDte="99/99/99") .Or. (Title<>"UCI EXTENSION"  .And. ToDte="99/99/99")

       

      I've searched your archive and faqs but still can't see the problem.

       

      Please help.

       

      Amadea

        • My filter isn't filtering!?
          Amadea _

          Sorry....I finally figured it out.  Should have used .And. instead of .Or.  Like this:

           

          (ToDte="99/99/99" .And. Title<>"SUSPENDED")  .And.  (ToDte="99/99/99" .And. Title<>"DIR STUDY") .And. (ToDte="99/99/99" .And. Title<>"UCI EXTENSION") .And. (ToDte="99/99/99" .And. Title<>"CLASS AUDITING")

           

          It's good to know this forum exists though.  I often run into little stags that only someone else's eyes can help me solve the problem.

           

          Amadea

          • My filter isn't filtering!?
            cardealers _

            Amadea,

             

            I learned the following from the beginning Monarch class:

             

            Use .OR.  if you are selecting across columns

            Use .AND. if you are selecting from the same row or rows.

             

            Something to remember.

             

            Cardealers