Difference between Termly Attendance

I'm doing some work for a school and want to be able to show the difference in attendance between academic terms. I have a date table set up and I have allocated a Term (1,2,3,4,5,6) to each date bas...