3 Replies Latest reply: May 15, 2014 10:02 AM by jkl123 _ RSS

    Filter Help

    jkl123 _

      I'm having trouble creating a filter for a range of numbers. For example I would like to exclude numbers between 700-799. Or I would like to exclude numbers that start with the number 7. Any suggestions? Thanks for you help.

        • Filter Help
          Data Kruncher

          To exclude (account) numbers that start with 7, try:

          Left(Trim(Str(Account)),1)<>"7"[/code]

            • Filter Help
              Grant Perkins

              For the Range, and assuming your numbers are numeric rather than alpha,

               

              Fieldname <700 .or. Fieldname >=800

              should do it.

              If the field is alpha but can be treated as a numeric range convert to numeric first.

              Val(Fieldname) <700 .or. val(Fieldname)>=800

               

              If the filter get more complicated than that consider creating each filter in a simple form and then using the simple filters to create a Compound filter or a compound of compound filters to bring them all together.

               

              If you have lists of values to include or exclude you can also use the .IN. and .NotIn. operators in the filter definition tool.

               

              HTH.

               

               

               

              Grant