When following DAT Query - Step 1 procedures, you have an option to add conditions to any table in your DAT Query. The option to add conditions is presented:

    - after DAT Query - Step 1 - Choosing Initial Table

    - after DAT Query - Step 1 - Connecting Tables

    - after you navigate to DAT > Queries > Query and click on any chosen table in your DAT Query 


To add conditions to your DAT Query:

1. Specify condition criteria by:
    - Selecting Field to add DAT Field Condition
    - Selecting New Filter to create a brand new DAT Filter to add as a condition.
    - Selecting Saved Filter to use a saved DAT Filter as a condition

2. Click Add to add the condition 

3. Check “Parameterize” checkbox to turn any simple condition into DAT Parameterized Condition if desired

Repeat steps 1, 2, and 3 for each condition.

4. When you add more than one condition for the chosen table, you have an option to change how these conditions interact using parentheses as well as specifying AND or OR logical modifiers using the provided logical conditions box.  If you make any OR conditions, be sure to include parentheses to ensure the order of operations are as desired. Note: The default behavior is to AND all conditions together.

Note: Click the Save button to save conditions and exit the table properties wizard.
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.