1 Reply Latest reply on Jul 4, 2012 10:36 AM by philmodjunk

    Exclude records with empty field



      Exclude records with empty field


      In my registration database I have had to add a field for "Date Dropped" to designate that a student enrollment has been dropped.  I don't want to just delete the record because of the fees associated to the record.

      Obviously when I generate a class roster, I don't want the dropped enrollment to be included.  


      Would it be better to Omit records that have a value in the "Date Dropped" field or to Find records that have no value?  I know how to do the former.  What would be the safest way to do the latter?