Recent content by rnickel

  1. R

    IIF returns 0 instead of boolean

    I did, yes. But it's the top result that comes up in Google on the question it raised, and it still didn't have a single response that actually just answered the question; only three pages of the usual "why do you want to do it *that* way?" So, I figured: high time.
  2. R

    IIF returns 0 instead of boolean

    Here is the actual answer to what the OP wanted to do, which is the same as what I was trying to do: namely, display Boolean values in a calculated column as checkboxes instead of numeric values. (I was using IsNull rather than IIf, but had the same issue.) 1) In table design view, select the...
Top Bottom