Incorrect Results in Query for Total Memberships

When working in a constituent query and querying on Summary Information for Memberships, Total Memberships may produce incorrect results and/or output incorrect information. 
Within a constituent query, the Summary Information for All Memberships field outputs each constituent associated with any membership of the constituents who meet the criteria. So if Constituent A has 2 memberships, and one of those memberships also includes Constituent B, both constituents will show up in the results. 

In order to only display those constituents who have 2 or more memberships, use a Membership query:
  1. Create a membership query
  2. Add the following criteria:
    1. History > Summary Information for All Memberships > Total Memberships is greater than or equal to 2
  3. Add desired output
  4. Run query

 

Steps to Duplicate

  1. Log into the Raiser's Edge
  2. Navigate to query and create a new query
  3. Add the following criteria:
History > Summary Information for All Memberships > Total Memberships is greater than or equal to 2
  1. Add desired output
  2. Run query and check results
    1. Constituents with 1 membership appear in the results

Was this article helpful?