List of alumni Query

Susan Stanislas 2

I am building a Query and I have it figured out in my head, but I can't seem to get it right.


I want a list of Alums, whose parents are coded in Bio 2 as Parents of Alum and also Alum


So I have


Individual Relation Reciprocal one of Daughter, Son

AND Constituency Code equals Alum

AND Individual Relation Relationship one of Father, Mother

AND Constituency Code one of Parent of Alum, Alum


Any ideas anyone?


Thank you for all your help

 

Aaron Rothberg

Assuming this is even possible in one query, I tried something similar to your criteria and I can't get query to respect the Individual Relation Constituency Code of both Parents of Alum and Alum. In my example below, Dad Rothberg is the only person that has both Constituency Codes Parent of Alum and Alum. Mom Rothberg only has the Alumnus Constituency Code so I don't want to see that relationship, yet it's coming through in Results.



 

Susan Stanislas 2

I see what you mean.  I tried it but there is an alum who is not on the list.  Her father is coded Parent of Alum and Alum, but his daughter does not appear on the list.  Need to think some more

 

Christine Cooke 2

So instead of looking for the Parent having a constituent code of Alum, instead query on their primary education class of being greater than or equal to... pick a year.


So the query is

Constituent Code = Alum

AND

Relationship Individual Constituent Code = Parent of Alum

and Relationship Individual Primary Education Class of greater than equal to....__

Susan Stanislas 2

Thank you I will try that and let you know the
outcome.

--

Susan M.
Stanislas

Advancement Database
Manager

Notre Dame High
School

13645 Riverside
Drive

Sherman Oaks, California
91301

818-933-3692

ndhs.org