Start a new topic

Attendance Query

We are trying to build a query that will search students by how many times they are absent in a period. They want to be able to change the total amount for each period.


Has anyone built a query that they could share that will do that??/

1 Comment

Hello Wendy,


The Attendance Query Bank is a resource of various attendance queries.  Query banks are the first FAQ in each category in Freshdesk.  


Period ATT:  List of Absence Entries for a 1st Period Class on a Specific Date 

List of student Absence Codes for a 1st period section with Attendance Date on a Specific Date


This query was adjusted from the list of queries and is run for 1st period after a specific date - you can add/modify to reflect the periods you are searching for.  


LIST STU SEC MST ATT STU.ID STU.NM SEC.SE ATT.DT ATT.A1 IF ATT.DT > ##/##/20##


If you need further assistance, please submit a support ticket through Freshdesk.


Susan Prow

Aeries Support



Login to post a comment