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 not married, and second, how to find families with children but not add the children to your results.
If you are not familiar with IQ, please watch this video first: IQ - Overview (Video)
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.
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
Then Execute Query and the results are your single parents.