add spouse primary constituent code as a query (and export) field

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.

  • Guest
  • May 16 2013
  • Attach files
  • Guest commented
    March 18, 2016 01:17

    spouse consituency code not one of "board member" or (spouse consituency code equals "board member" and spouse consituency date to "not blank")

  • Guest commented
    March 18, 2016 01:17

    Jonathan - are you agreeing with me or trying to suggest something?