[SQL] MSAccess Where Clause with Case statement syntax error...
 

Is there something obviously wrong with this where clause?

I've been staring at this for a while, and I can't get it right. Access just gives a generic syntax error (missing operator) for the case statement.

Want to know what the problem was?


Access doesn't support case statements!

Kill me now. :)

Access's default SQL doesn't support a lot of things.

Will it work as a pass-through query? We do a lot of this where I work when someone needs Access to interact with an outside database. Access tries to format all SQL into Access-deformed-SQL unless you specify that the query is a pass-through query. (Not sure if this will help if your data is in Access as well).

w0