Ok what I want to do is very simple but nothing I have found is helping me.
I have a field that sometime contains a values 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 cant 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:
MicroSoft Access 2007
February 14, 2010 1:30 PM
February 16, 2010 3:02 PM