Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using the “Is Not Null” but no matter how I use it I can't seem to get it to work. The fields name is “1st Position Held Elected or Appointed” Any help would be greatly appreciative. This is what I’ve tried and various versions of this:
IIf([1st Position Held Elected or Appointed] Is Not Null,"25")
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!