Count Checked boxes on report

[BLFOSTER]

Hi. I have a report for attendance of students. It is grouped by unique student ID. I have summed each students expected hours for the month in a text box and summed each students actual hours for the month in another text box. If the student has perfect attendance then my checkbox = true ([check65]). This report is for the Month of May, and attendance is tracked by WEEK, so in the detail section under each unique identifier group header, there are 4 records - 1 for each week for each student. I want to JUST count how many check65's are true - a total number of students who have perfect attendance for the MONTH. I have tried many other methods but always get the count of all the detail records which I do not want. For example: Sum(iif([Total Actual Hours]-[Total Expected Hours]<=0,1,0)) counts all the detail records when I put the expression in the report header or footer. Any ideas?


Thank you

[ranman256]

your query must have all possible days in the week AND the days they attended to count.
if DayAttend = DaysInWeek then PERFECT ATTEND=TRUE

[BLFOSTER]

Thank you. That wouldn't solve my problem, but I figured it out. I am using a "totals" query w/unique values for each calculation and this is working fine.