Can you post a screenshot of your query in Design View?

There's a lot that I would change with this query. First, you've got tables and queries with dashes in the names, and fields with spaces in the names, so you are definitely going to be needing brackets. You got a field named Date which is a No-No. And if you're going to be checking for the actual word yes or no then you're going to need quotes around that.