Forum Discussion

Qrew Cadet

3 years ago

How to write an IF Statement to look for NOT null

In our app we converted 400 projects that had historical SPONSORS as a text field. Approximately half of the projects are closed so we plan to keep a Sponsor-Historical (text field) for closed p...

Formulas and functions

AnnettaColeman

Qrew Cadet

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
------------------------------

MikeTamoush

Qrew Commander

3 years ago

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
------------------------------