& 是“逻辑与”操作吧? 试试吧: select * from table where (flag and 4)=4
to KingSunSha(弱水三千) 试过了,会报错,它把and 作为条件判断不知道是不是mdb不提供 & 操作,请大家帮帮忙
那就这样吧。ACCESS支持自定义函数,在MODULE中建立一个函数: Public Function MyAnd(A As Integer, B As Integer) As Boolean MyAnd = A And B End Function然后你的SQL可以这样写: select * from table MyAnd(flag, 4)试过了,可以成功
试试吧:
select * from table where (flag and 4)=4
试过了,会报错,它把and 作为条件判断不知道是不是mdb不提供 & 操作,请大家帮帮忙
Public Function MyAnd(A As Integer, B As Integer) As Boolean
MyAnd = A And B
End Function然后你的SQL可以这样写:
select * from table MyAnd(flag, 4)试过了,可以成功