Bitwise

H

Hermione

Hello

I'd like to now how can I use a bitwise

I want the result of [Tb_COM].[ID_COM] & 1
[Tb_COM].[ID_COM] & 4

Thanks
 
A

Allen Browne

Use the BAND operator for a bitwise AND.

That has to be executed under ADO code, though.
DAO - the native Access library - is not able to do this, and consequently
the query design window cannot understand it.

Works in JET 4 only (Access 2000 and later.) In older versions, you would
need to use a VBA function call in your query.
 
Top