Criteria Question

[Lamb2087]

I have a field titled Dorm_Plan. When a student leaves it says clear for them in the field. I am trying to display the students that
are currently here. I have used Not"Clear" in the criteria for this field, no luck. Is there something better to put that would work. I want to display everything that does not have clear in this field.

 

[Rich]

Try <> "Clear" , but what is in the field when occupied, if it's just empty you could put Is Null in the criteria

 

[Lamb2087]

Rich
Got it fixed. If you put it in the correct field it usually works

The field will have a dorm room if the student is here, but has clear when they leave.