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
      Drop here to upload
    • 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?