I have this report which includes names, sex, race, ArrestDate, and a check box for release. Each inmate's name must display for as many times as necessary, however, there should only be one Release check box per name. If the inmate is released, we check the box. I want to count the number of boxes that are not checked. How can I do this? I know how to count all records (over all, and over group), but I have never had to count checkboxes that have not been checked. Can anyone suggest anything? Thank you.

Create another table to keep track of inmate and his (real) release date ("tblRealease"). In the table with the arrrest info there could be a release date associated with that arrest ("tblOffense"). tblRelease is populated if an inmate has release dates for every arrest in tblOffense.