Enter Find mode //clear the pause check box
Set Field [Yourtable::yourField ; //put criteria that will not match "canceled" but will match the other records here]
Constrain found set
If this field is empty unless "Cancelec" was entered, you can enter "=" here to constrain the found set to records where this field is empty.
If it has a status of "active" specify that criteria
or anything else that matches this approach.