I need to count consecutive numbers of missed attendances

[#1]

I have a model that contains a table that counts the number of Attendances, Authorised Attendances and the number of Missed Attendances for my students. Everything works fine however I cannot get it to count the Consecutive Number of missed attendances (identified as Absent in my table). I have also tried full accumulation but that does not work.

I created a field called lastday attended and did a count and sum from that but that gives to many missed attendances as we work on academic terms so it assumes too many attendances have been missed since the last attendance date and it will not work for those who have not attended.  I am sure there must be a straight forward method for doing this but as of now I have not found it. If anyone has a solution please advice me on hte best way to do this.

[hic]

I would create a field ConsecutiveMissedAttendances already in the script. If you look at Counters In the Load, especially how "DaysWithTrend" is created, I am sure you will be able to solve your problem.

HIC

[MK_QSL]

Better help can be provided if you can provide sample data file.