- Duplicate memberships showing in query when there is more than one member: Add the criteria of Members\Primary member is equal to yes to only show one membership per query row.
- Cancelled memberships are showing in the query: Add the criteria of Member\Memberships\Status is not equal to Cancelled.
- Members who are no longer on the membership are showing in the query: Add the criteria of Members\is dropped is equal to no.
- Output Member\membership\Membership Transaction\Action to compare the number of actions to the action in the Activity Tab to determine where you are off.
Connect and collaborate with fellow Blackbaud users.