Home > IT Answers > Microsoft Windows > MS Access 2007, IIF and Null expressions
Phil12550
120 pts.
 MS Access 2007, IIF and Null expressions
Access 2007, IIF, Microsoft Access, Null Expressions
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")



Software/Hardware used:
MS access 2007
ASKED: February 15, 2010  1:25 PM
UPDATED: May 9, 2013  4:27 PM
RELATED QUESTIONS
Answer Wiki:
You could use the IsNull Function. Something like this: 
<pre>IIf(<b>IsNull</b>([1st Position Held Elected or Appointed]),<something else>,"25")</pre>
Last Wiki Answer Submitted:  May 9, 2013  4:27 pm  by  Michael Tidmarsh   11,410 pts.
All Answer Wiki Contributors:  Michael Tidmarsh   11,410 pts. , carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Try this
nz([1st Position Held Elected or Appointed], ’25′)

msi77
 1,610 pts.