- On Criteria tab, select: Relationship, Relation, Student, Relation current status equals equals [status]
- Save and close the Query.
- On Criteria tab, select:
Relationship, Relation, Student, Relation current status [status]
AND Address, Contact Information, Contact type equals Email
- Save and close the Query.
- Merge the queries. Select the first query as Query 1 and the second query as Query 2. Mark Select records included in Query 1, but exclude records included in both queries.