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?
Either method produces the same results. I don't really see any advantages to suggest that one is safer than the other. To Find records where a given field is empty, put a lone = sign in the field. This works as long as the field is not from a related table.