Need help Quering Yes/No fields

[seashton]

I have a Customer table of products used which uses 14 Yes/No fields and I want to use one report that will show all customers that uses a specific product but the report should also show all the other products those customers use. The report I made opens a form with a list of all the yes/no check boxes of products to choose from (only one product can be choosen). I have a query for the report that has the criteria for each yes/no field set to look at the corresponding yes/no field of the form. When the report runs I get no results and I know it is because there are no records where the field I choose is yes and all the other fields are no. The only way I can see is to create one report and query for each product, but that seems excessive, is there a better way???