I know it has been awhile since I have done this but it can't be this difficult. I have a report that I am creating that I need to run totals on. The report is grouped by product and each product has request for add, deletes, and maintenance. I have these set as yes/ no check boxes. What I need to do is the number of add, deletes, etc per group and then a final total. If I do a count in the query it counts each box not just the yeses. If I do a running sum it gives me a -1. Below is an example of the data.