Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
If you need to find single parents in your database, you need to solve two problems:
- How to find heads of multi-person households who are unmarried.
- How to find families with children but not add the children to your results.
Add results and conditions area you need, but be sure to add:
Click [edit sub-query] for not in sub-query.
Within this sub-query, click [Add new condition]: Members Member Type is in list Husband.Wife
This will eliminate anyone who is married.
Click OK.
Edit the next sub-query to make sure the family has members under the age of 18.
Click [edit sub-query] for in sub-query. Within this sub-query, click [Add new condition]: Members Age is less than 18:
Click OK.
Then Execute Query and the results are single parents.
Updated