I am trying to get a report off a data based used for tech services. If parts fail under warranty the tech will click a text box set up for all the major parts.
I want to have the query gather only boxes that are checked which it does now bit I want to know how many of each checked box.
There are a total of about 20 check boxes and I need a count of each group of check boxes checked.
For instance;
Check boxes Blower, sensor, control, gas valve ETC.
Report how many of each group.
Thanks in advance.