Begin your query:
  1. Navigate to Analysis, click on Information library
  2. Click to Add an ad-hoc query
  3. Select the source view of Memberships
Add fields to Include records where:
  1. In the left column, select Membership transaction. From the middle, drag Comments into Include records where. Set Equal to your Comment.
    • Note: This is spelling sensitive.
  2. (Optional) To see only the primary member: In the left column, select Member. From the middle, drag Is Primary into Include records where. Set Equal to Yes.
Add fields to Results fields to display:
  1. By default, Membership ID is included within Results fields to display
  2. In the left column, select Membership transaction. From the middle, drag Comments into Results fields to display.
  3. To include member name: In the left column, expand Member, then select Constituent. From the middle, drag Name into Results fields to display.

Save your query:

  1. Click the Set save options tab
  2. Name your query
  3. Save and close