2 Replies Latest reply on Feb 2, 2014 3:58 AM by alex

    Finds

    alex

      I have a query which is as follows

      Find all fields which are empty (=)

      Next find: Exclude two companies which the primary key is x

      X and Y (on the same field)

      Next find: Number field with value between 0...62 AND / OR an other number field with a value smaller than 3500

      Next find: Date field VALUE more than 3 months later than current date

       

      I already have a headache of two hours working on it. Who can help?

        • 1. Re: Finds
          taylorsharpe

          You might want to do a screen capture of the script and show it to us here and I bet we can help you out. 

           

          Basically, you narratively have it already laid out.  Do you really want to find a record where all fields are blank as you said above or are you looking for any fields that are blank where you would be making an OR statement between each request. 

           

          Enter Find Mode

          Set Field ____ ; "="

          Set Field ____ ; "="

          Set Field ____ ; "="

          Set Field ____ ; "="

          Set Field ____ ; "="

          ... to the last field   (If you want this to be OR, you put a New Record Request between each line)

          Perform Find

          Enter Find Mode

          Set Field Company ; "x"

          Omit Record Request ;

          Contrain Found Set

          Enter Find Mode

          Set Field Company ; "y"

          Omit Record Request ;

          Contrain Found Set

          Enter Find Mode

          Set Field Number ; "0...62"    (Not sure if you wanted "<3500" or what your "AND / OR" means above

          Contrain Found Set

          Enter Find Mode

          Set Field Date ; ">" & Date ( Month ( Get ( CurrentDate ) ) + 3 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) )

          Contrain Found Set

          • 2. Re: Finds
            alex

            Taylor,

            Thank you for your answer. The first request ist: find all customers without a remark. (Remark field blank)

            Set field remark "="

            the <3500 is an AND

            I will add all the rest of your script and it should work. I will let you and again thnaks