How to create a report of all children born within a date range
From the IQ module, set up a new query and add Result Columns
- Families: Last Name and Families: First Name (this will be the parents)
- Members: Full Name and Members: Birthdate (also add whatever address info you need from Families: Contact Info)
Now add the Query Conditions
- Members: Birthdate: is between: (your date range)
- Families: is Registered: is equal to: Yes
-
Organization: Organization ID: is equal to: (Your Org ID here)
- Then Execute Query. When the results appear, create a report by:
- Click Query Results and choose Export to CSV.
- Save to computer.
Related Articles
How to export query results to a .csv file
How to add, edit, or remove a condition
How to add, remove, or replace a column
How to assign a tag to a query
How to create and manage query tags
How to create sub-queries in IQ
Updated