Return all results matching the search criterion

In your combobox group the data so you only have one of each type. Depending on how you plan on displaying the results, you can have the subform listing company names. Then set the filter to the "Ccdi..."
Same with the yes/no filter to "Yes" and if the results are group by you can get a count of the answers.
You can use the table as-is. Just group the data in the combobox.