In Access97 and Access2000, the "AND" operator will work logically but not bitwise on numeric types if used in the data source property of the field on a report or in an eval() function either in a data source property or in a function. Have not fully explored forms and queries in this regard yet. The only instance that I can find where "AND" works as advertised with numeric types is in a function.
Has anyone else encountered this? Has anyone found a Microsoft acknowledgement? How about a patch?