- Go to Analysis > Information Library
- Click Add an ad-hoc query
- Select the Source View of Constituents and click OK (this can also be accomplished through a memberships query, but this method is more direct if you'd like to output the Primary Member Name in your results).
- In the left column, expand Member. From the middle column, drag Primary Member to Include Records Where. Set this to be equal to Yes. Your field will appear like this: Member\Primary Member is equal to Yes.
- In the left column, highlight Membership beneath where you expanded Member. From the middle column, drag any fields you would like to include in your filters such as Membership Program, Membership Level, or Membership Status. For example: Member\Membership\Status is equal to Active and/or Member\Membership\Membership Program is equal to General Membership. At this point, you can also drag any fields you'd like to see about the memberships in the Results to Results Fields to Display. For example: Member\Membership\Membership ID, Member\Membership\Membership Level, or Member\Membership\No. of Children, etc.
- Next, expand Members beneath Membership. This is looking at the membership record and finding all of the constituents (including the Primary Member) that are linked to the Membership. From the middle column, drag Is dropped to Include Records Where. This will eliminate any members from your count who have since been removed from the membership record. Your field will appear like this: Member\Membership\Members\Is dropped is equal to No.
- Highlight Constituent beneath where we expanded Members in Step 6. From the middle column, drag Lookup ID to Results Fields to display. Your field will appear like this: Member\Membership\Members\Constituent\Lookup ID.
- In Results Fields to display, highlight Member\Membership\Members\Constituent\Lookup ID. Click the Sigma Sign and select to Count the Lookup IDs as pictured below. This will provide a count of all of the unique constituents listed on a membership record.
- Your final query should look similar to this one:
- On the Set Save Options Tab, provide a name for your query and click Save so the query will be accessible later.
Connect and collaborate with fellow Blackbaud users.