Microsoft Query is dumb and will automatically turn Syntax 2 into syntax 1.

But you can apply syntax 2 to youur SQL string in VBA code: it works fine.

HTH
--
AP

"Wim" a écrit dans le message de news:
...
Thanks Harald, but I knew. The SQL examples in my mail are just
"logical" examples, my actual code is written correctly (without "").

My question is not related to characters, those are OK. It's rather
about the logical structure of the SQL statement.

Instead of

A and X or B and X or C and X or D

I'd like to use

(A or B or C or D) and X