New to Query? Check out Getting Started with Query (PDF) to understand basic concepts and create your first query—all in a matter of minutes!
 

To query on constituents with an active bank account:

  1. Create a Constituent query.
  2. On the Criteria tab, select: Relationships>Banks>Account is Inactive equals No.

To query on constituents with an inactive bank account:

  1. Create a Constituent query.
  2. On the Criteria tab, select: Relationships>Banks>Account is Inactive equals Yes.