2 Replies Latest reply on Jan 1, 2011 4:27 PM by JohnMozzer

    How Do I Tell Find to Omit Records With Blank Field

    JohnMozzer

      Title

      How Do I Tell Find to Omit Records With Blank Field

      Post

      I am working with an old database with 930 records.  Years ago, when I designed the database, I created a field named Comments, which I sometimes used to write notes, and other times did not use.

      In 410 of the records, the Comments field consists of notes.  In the other 520 records, the Comments field is blank. 

      How do I tell Find to bring up only those 410 records where something (anything!) is written in Comments, and omit the records where Comments is blank?