Support

Aeries Query - Find Summer School Enrollment in Prior Year Print

Modified on: Fri, Dec 13, 2024 at 4:13 PM

Query to find which students are still enrolled in the current year database, that also attended last year's Summer School:

LIST STU ENR STU.ID STU.FN STU.LN ENR.YR ENR.SC IF ENR.YR = 2022 AND ( ENR.SC = 123 OR ENR.SC = 345 OR ENR.SC = 567 )

Change the numbers in bold to the School Codes for Summer School. This can be found in the School Options page.

Next Article: Aeries Query - Why isn't the Extended Field SPECIALED Pulling all Students with an Active Special Education Record?

Did you find it helpful? Yes No