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

    Exclude records with empty field

    PatriciaSamuelsen

      Title

      Exclude records with empty field

      Post

      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?

       

      Thanks,

       

      Pat