HISTORY: I sent out an online web survey to all users at all locations of our company, asking which of several training classes they would like to take. They indicated which classes, by checking a box in front of the class. When they hit Submit, the results were dumped into a database (with a YES entry where they checked a box, and a blank where they did not). Now I’m attemping to analyze that information.
I have created a qry that will do a count of all users who want to take class A or B or C, and I can specify which location by including the “Facility” field. Doing a count query for how many people want to take each class at a single location is easy enough. I can even do searches on multiple locations by specifying ” ‘FacilityA’ OR ‘FacilityB’ ” in the criteria and it will return a count/total for each class at those specific locations. But, I would like to total all results from FacilityA AND FacilityB – and when I type just that in my Facility Criteria I get bubkus – I guess because it is looking for instances where someone from FacilitiesA and B selected a course, and that will not exist because user’s only work in one place or another. Can anyone help me get my syntax right? Better yet, can anyone understand what I’m trying to do ?!?! 
