How to query for single parents
If you need to find single parents in your database, you need to solve two problems: First, how to find heads of multi-person households who are unmarried, and second, how to find families with children but not add the children to your results.
First, add whichever results columns you need, but be sure to add: Families --> Last Name and Families --> First Names (these are the parents' names from the front of the Family Details). And Families --> Family DUID
Next add these conditions:
Families --> Family DUID not in sub-query and
Families --> Family DUID in sub-query
Click [edit sub-query] for not in sub-query. Within this sub-query, click [Add new condition] --> Members --> Member Type is in list type Husband,Wife
This will eliminate anyone who is married.
Click OK
Then we 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 and type 18
Click OK
Then Execute Query and the results are your single parents.
Updated