Counting Multiple Check Box Fields

[razorkat99]

I have different fields in a table that I need to combine and count as one item. For instance, I have check boxes on my form for POTS/DSL_In and DSL_In that I want to combine in my report as just DSL and have them counted. So, if my records have 4 check boxes total selected for POTS/DSL_In and 3 selected for DSL_In, my total on my report should read DSL = 7.

I'm not sure where to even begin with this (newbie). Not sure if it should be a query, and if so, how to do the calculation in the query or if this is something I can create directly in my report using a calculation and what that might look like.

Thanks.

 

[pbaldy]

You can use the same technique as your other thread, but add them together:

=Sum(...) + Sum(...)

 

[razorkat99]

Awesome! Worked like a charm. I even figured the next calculation out myself. Only a couple more to go for THIS report.