With Secondary Scheduling, how can I query student Course Attendance Records (CAR) for a specific teacher for Census Day? 

Find the Teacher Number on the Teacher Page and replace XX with the number. 

LIST STU CAR TCH STU.ID STU.NM CAR.SN CAR.CN CAR.SE CAR.DS CAR.DE CAR.TN TCH.TE IF CAR.TN = XX  AND ( CAR.DS <= 10/xx/20xx AND ( CAR.DE = NULL OR CAR.DE >=  10/xx/20xx ) )   

• CAR.DS  and CAR.DE date of 10/xx/20xx is the Census Date for the current year