Counting Attendance Checkboxes per ID

[Rshukis]

I have an access database right now that I am trying to use to track student attendance. Before I just had each day of school as its own field and I had to go through and count manually all the days that a student missed. I read about some checkboxes that I could use in a form but the problem is that I cannot figure out how to sum up all of the checkboxes (days missed) for each student. So I think I need to know how to run a query to count the number of days missed (checkboxes checked) per student.

[June7]

Each day of school is a field? Tables have a limit of 255 fields. You must have used all or close to it.

This is not a normalized data structure.

There is no intrinsic function to count fields of record. A conditional calculation in a query or textbox can but the expression in this case will be too long. This will require VBA code.