Attendance Query

I'm looking for a query that will tell me if a student has X or more
absences (absent value) in any one class period within a date range. The
report will be used to merge with an attendance form letter.