I am trying to query on a group of donors who were credited or soft credited for a particular gift (I am using SC to recipient). I need to exclude board members and their spouses.
I can exclude any board members based on primary constituency code but under spouse I do not have the option to use primary constituency code. I am now going to have to hand pick these people out by eyeballing them. Not good.
Please add primary constituency code as a query field under spouse and if it is not already there - add it as an export field for consistency.
spouse consituency code not one of "board member" or (spouse consituency code equals "board member" and spouse consituency date to "not blank")
Jonathan - are you agreeing with me or trying to suggest something?