Welcome back to the 2023-24 School Year! If you are a Parent and need information about the Aeries Parent Portal,
click here
. Otherwise, you can
dismiss this
.
Support
Sign in to Aeries Support
Enter your search term here...
Search
Start a new topic
Discussions
Discussion Topics
Attendance
Attendance Query for a Specific Date
C
Cheryl Untalan
started a topic
over 2 years ago
We would like a query having the following criteria:
Grades 3 and under (STU.GR < 4)
For a specific date (ATT.DT = 03/03/2021)
For all students (grades 3 and under) regardless if they have an all day code or not
Sorted by Teacher name (TCH.TE)
I have used the following query and it only provides me the students who have an all day code:
LIST TCH STU ATT STU.ID STU.NM STU.GR ATT.DT ATT.AL STU.CU TCH.TE BY TCH.TE IF ATT.DT = 03/03/2021 AND STU.GR < 4
I want the query to provide me ALL students in grades 3 and under regardless if they have an all day code or not.
Login
to post a comment
More topics in
Attendance
Absence/Tardy Codes
ISN
Attendance Letters by Attendance Percentage
Mass Add All Day ATT Code for One Weekday Only
Single Day Attendance Enrollment -- Leave date is the same as enter date
Daily enrollment by class query
Attendance Note skips Time to Leave Field
Aeries Down
Attendance Query for Tardies
See all 13 topics
Cheryl Untalan
We would like a query having the following criteria: