Hello folks,
I have a short question with respect to the usage of the AND operator in queries.
in VBA, "AND" can be used to make to make a bit by bit comparison of integer numbers, e.g.
? cbyte(47) and cbyte(254) yields 46
It's precisely this function that I would like to reproduce in a query field. However if I include the very same expression:
Expr1: cbyte(47) And cbyte(254)
or something more useful like:
Expr1: cbyte(
.[IntegerField]) And cbyte(254)
I get invariably "True" or -1 as a result of this field.
Can anybody help, what I need to do get the result of the bitwise operation without the need to call a customized vba function from the query.
Many thanks
Jan
PS: cbyte() only used for clarity ... straight numbers yield the same results
I have a short question with respect to the usage of the AND operator in queries.
in VBA, "AND" can be used to make to make a bit by bit comparison of integer numbers, e.g.
? cbyte(47) and cbyte(254) yields 46
It's precisely this function that I would like to reproduce in a query field. However if I include the very same expression:
Expr1: cbyte(47) And cbyte(254)
or something more useful like:
Expr1: cbyte(
I get invariably "True" or -1 as a result of this field.
Can anybody help, what I need to do get the result of the bitwise operation without the need to call a customized vba function from the query.
Many thanks
Jan
PS: cbyte() only used for clarity ... straight numbers yield the same results