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) A
- Members: Full Name and Members: Birthdate (also add whatever address info you need from Families: Contact Info)B
Now add the Query Conditions
- Members: Birthdate: is between: (your date range)C
- Families: is Registered: is equal to: YesD
Organization: Organization ID: is equal to: (Your Org ID here)E
- Then Execute QueryF. When the results appear, create a report by:
- Click Query ResultsG and choose Export to CSV.
- Save to computer.