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

1. Families: Last Name and Families: First Name (this will be the parents) ^A
2. Members: Full Name and Members: Birthdate (also add whatever address info you need from Families: Contact Info)^B

Now add the Query Conditions

3. Members: Birthdate: is between: (your date range)^C
4. Families: is Registered: is equal to: Yes^D
5. Organization: Organization ID: is equal to: (Your Org ID here)^E
   
6. Then Execute Query^F. When the results appear, create a report by:
7. Click Query Results^G and choose Export to CSV.
8. 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 a new query

How to create and manage query tags

How to create sub-queries in IQ

How to delete a query

Top

April 17, 2023 18:13