There are a few different ways in the DAT Fields - Step 2 process to handle duplicate data in a query.  The options in the drop-down include:

    - All Rows will show all rows which could include duplicate rows.

    - Unique Rows will remove duplicate rows from the results.

    - Unique Rows with Count will remove duplicate rows from the results, but also include a count of how many times that particular row would have appeared.

See also
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.