It is a dangerous assumption. NOT can be a bitwise operator
on
integers.
But it's not in VBA, which is what you'd be using in Access.
Of course, it's certainly true that you could be using it in SQL, as
well, but if you're not writing passthroughs, it will be executed by
Jet/ACE, so results will be reliable.
In two's-complement arithmetic, NOT 1 equals -2, and both
are considered true by the non-zero is true assumption.
If this is a concern, use a boolean type. If you can not do
that, then determine true and false using something like
true=0=0
false=not true
and then use those variable where you need boolean values.
I don't think any of this is relevant to any circumstances in which
one would be using Access as one's development platform.
That WAS what we were talking about, no?