PSFS IQ - Family Directory: How to create a report of all members or children born within a date range

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

  1. Members: Birthdate: is between: (your date range)C
  2. Families: is Registered: is equal to: YesD
  3. Organization: Organization ID: is equal to: (Your Org ID here)E
  4. Then Execute QueryF. When the results appear, create a report by:
  5. Click Query ResultsG and choose Export to CSV.
  6. 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



Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request