- Create a query of all students who have a current status of Graduated/Withdrawn
- Save this query
- Create a query of all students who have a current status of Graduated/Withdrawn but also have current student siblings by adding the following criteria:
- Expand Relationships>Relationship one of [Sibling] Expand Relationships>Relation>Student>Relation Current Status equals [Current Status]
- Save this query
- File>Merge
- Query 1: Choose query with all students with the status of Graduated/Withdrawn
- Query 2: Choose query with students with current student siblings
- Choose the option to include only records in Query 1 but not in both queries
- Merge Now
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.