• 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.