2 Replies Latest reply on Mar 1, 2012 9:31 AM by Sam2

    Sort if there is anything in the field

    Sam2

      Title

      Sort if there is anything in the field

      Post

      I'm sorry for such a basic question. but, how do I sort a database so that only the entries that have info in one of the fields come up and conversely, how do I sort the entries that have no information in one of the 8 fields?

      I see the posts on here that show command lines but when I do a sort just one empty line from my database comes up. I can't even see where I would enter comand lines...

      Thank you,

      Sam

        • 1. Re: Sort if there is anything in the field
          philmodjunk

          You appear to be confusing the process of sorting records--ordering the current found set into a specified order and finding records--pulling up a found set of records matching specified criteria.

          To find all records where a given field is empty, do this:

          Enter Find mode (click find button in status area)

          Enter a lone * in the field

          Perform the find (click perform find button in status area)

          This can also be scripted.

          To find records where a given field is empty, use = instead of the * operator.

          To find records where either field 1 or field 2 is empty:

          Enter find mode

          Put = into field 1

          Select New Request from the Requests menu

          Put = into field 2

          Perform the find

          To find records where the field is empty in one of 8 fields, you'd use this last method, but create new find requests so that you can put the = operator in to the 8 fields--each on a different find request before performing the find.

          • 2. Re: Sort if there is anything in the field
            Sam2

            thank you so much!