I need a query for the field,” defect category”,( that is a dropdown). All the values in the drop down should be broken down in their category . Then I need the totals of each category. Then I need to take that query and make a report. For example:
LOCATION DEFECT CATEGORY
I have enclosed my database for further explanation.