1. Go to Analysis > Information Library.  
  2. Click add an ad-hoc query and select the source view of Constituents and click Ok.
  3. In the left column, expand Member. In the middle, click on Is Dropped and move to Include Records Where.  Set the criteria is equal to No.
  4. In the left column, beneath where you expanded Member, highlight Membership. In the middle column, move Membership Program to move to Include Records Where.  Set the criteria to equal to your membership program name.
  5. Also in the middle column, drag, Membership ID to Results Fields to Display. 
  6. Once Membership ID is in Results Fields to display, highlight the field. Click the Sigma sign and choose to COUNT it: Count Membership ID
  7. Next, add anything additional you would like to Results Fields to Display to help you identify these records. For example, you may want to add Lookup ID. You will highlight Constituents at the top in the left column and drag Lookup ID to Results Fields to Display. Here is an image of what your final query might look like: Example of finished query
  8. The last step is crucial to identifying constituents with more than one membership. We need to tell Altru we want every constituent who has a Membership ID count greater than one (anyone who has more than one membership. To do this, go to the Set sort and group options tab.
  9. Click Count (Member\Membership\Membership ID) and drag this to Include Records Where in the bottom right.  Set the criteria to greater than 1. Here is what your Set sort and group options tab should look like: How to filter on the count
  10. Go to Set Save Options.  Name and save your query.

For more information on how to merge these multiple memberships, see our Knowledgebase article with steps to merge memberships in the same program together.