View Single Post
  #1  
Old December 20th, 2006, 07:38 PM posted to microsoft.public.access.forms
chickalina
external usenet poster
 
Posts: 194
Default IFF Statement, 3 options

How come this doesn't work?

=IIf(IsNull([txt_cumulamt7]),"",IIf([txt_cumulamt7]050,"","Benefit
Recognized"),IIf([txt_cumulamt7]1,"",""))

If the field is Null, then nothing appears
If the field is less than 50, but more than 0 then Benefit Recognized
If the field is 0, then nothing goes in the box
Thanks in advance!