Forum Discussion
Well Duh.... It works just fine if I use <> Null instead of IsNull = False. Amazing what clarity can be discovered via a Power Nap. Sorry to waste community time.
------------------------------
Annetta Coleman
------------------------------
------------------------------
Annetta Coleman
------------------------------
To add on to Mark's tip:
If you ARE testing a numerical field simply use:
isnull([Field]) to test if blank
not isnull([Field]) to test if not blank (versus isnull <>null....)
------------------------------
Mike Tamoush
------------------------------
If you ARE testing a numerical field simply use:
isnull([Field]) to test if blank
not isnull([Field]) to test if not blank (versus isnull <>null....)
------------------------------
Mike Tamoush
------------------------------