The only thing I can see (I think - text is small) is an un-paired ( in the WHERE line. I count one extra left parenthesis.
EDIT: never mind. I magnified the screen and I see that I missed one. What happens if you put the sql in sql view and attempt to run it? Sometimes the offending part will be highlighted, or at least close to it.
ISNULL is vba Is Null is sql. Not sure but I believe query design will automatically change ISNULL to Is Null; not sure about sql view.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.