How can we help you today?
Enter your search term here...
to submit a new ticket
Check ticket status
Start a new topic
Attendance Query for a Specific Date
started a topic
about 1 month 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.
to post a comment
More topics in
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