SQL SERVER (at least 7.0 and 2000)
--true condition
WHERE <your boolean field> = 1

--false condition
WHERE <your boolean field> = 0

True is -1 in JET - type cint(True) into the debug window.

As a general rule,

Please specify what versions of the software you are using.

Give some more details about how you are connecting to the SQL Server in VB.

Give some more details about what the error message was etc not just "It doesn't work".

HTH,

Peter