Start a new topic

Attendance Query for a Specific Date

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