For Census purposes you may need a list of all Families who have children. To do this you can create a simple Query with sub-query to pull the information for you.
Results Columns:
- Families > Family DUID
- Families > Last Name
- Families > First Name
- Families > Envelope Number
- Add contact and or/mailing data if wanted.
Query Conditions:
- Families > Family DUID not in sub-query
- Organization > Organization ID is equal to [POL].
- Click the option to Edit sub-query.
Edit sub-query Screen
In the sub-query add a condition for "Members Age" and set it to "less than" and enter the age.
Once finished, hit "Ok". The sub-query window will close and you may now run the query.
.
Run the query
- To run the Query, make sure the "Unique Records Only" box is checked at the bottom.
- Click Execute Query.
- To export results click "Query Results" and select Export to CSV and it will put your results in an excel file for easy sorting, printing, and viewing.
Related Articles
How to create sub-queries in IQ
Updated