Barand, Not to much to ask at all, but if one does not know, because one is new, then, well you understand, kicken and Barand. I found the problem. It's this. I am running a condition on a table that can only possibly give me one answer. tblDetails. I have to run it from the tblLocDet that contains all of the records of the details as well as the locations. I am testing it now and will return. Thank you both for your help.

If I put "Fireplace" and Private Room(s) I should get only the places that have both. And the answer is three, But I am getting five results because it's giving me all of the places that have a "Fireplace" AND/OR Private Room(s).

So you need to do it the same way I did in my thread. That's why I linked it. You need to structure your query the same way, because it's the only way to do that.

My goal in replying to posts is to help you become a better programmer, including learning how to debug your own code and research problems. For that reason, rather than posting the solution, I reply with tips and hints on how to find the solution yourself. See below for useful links when you get stuck.

If you post your entire code one more time, I'm going to lock this thread for good -- just post the relevant code snippet, nothing more. If you feel the urge to include the entire script, use an attachment.

fenway. Here is the solution I came up with. First I take all of te records that meet the criteria and insert them into them into a temp table. Then I do a count of how many times the LcationID appears and compare that against the number options that were selected. Then I run the query with those that equal the number of selected options. See what you think.