Start a new topic

Daily enrollment by class query

I am trying to create a query that tells me how many days each student was present in a specific class.  I was able to run a query that gave me when each student entered the class and when they left but I would like to not have to calculate the number of days myself.


This is the query LIST STU CAR CAR.CN CAR.PD CAR.SE CAR.DS CAR.DE IF CAR.CN >= 8013 AND CAR.CN<= 8092


This gave me the start and end date each student was enrolled in the class but can I add something to it to calculate how many days that is?  Or is there a better report to use?



Login to post a comment