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 1 year 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
Cheryl Untalan
We would like a query having the following criteria: