I've come across a really confusing problem, when I was attempting to build a workaround to the lacking Bitwise AND in access.
In excel - formulas in the header
|A||B : =MOD($A2/(2^0),2)>=1||C : =MOD($A2/(2^1),2)>=1||D : =MOD($A2/(2^2),2)>=1||E : =MOD($A2/(2^3),2)>=1|
In Access using the same data in column A but in an access table:
((ModuleBitWise/(2^0)) Mod 2) >=1 as Result0,
((ModuleBitWise/(2^1)) Mod 2) >=1 as Result1
((ModuleBitWise/(2^2)) Mod 2) >=1 as Result2
((ModuleBitWise/(2^3)) Mod 2) >=1 as Result3
I get the below:
Does anyone know what's going on here? I'm stumped and been looking at this so long that my brain is now mush. Excel is behaving as expected however Access isn't.