View Single Post
  #6  
Old December 20th, 2006, 08:24 PM posted to microsoft.public.access.forms
Steve Schapel
external usenet poster
 
Posts: 1,422
Default IFF Statement, 3 options

Chickalina,

Blimey, what you have in the description and what you have in the
quasi-expression are not at all similar.

If you go by the description, I would try it like this...

=IIf([txt_cumulamt7]=0,Null,IIf([txt_cumulamt7]50,"Benefit
Recognized","Continue Assessment"))

--
Steve Schapel, Microsoft Access MVP

chickalina wrote:
Actually, upon further discussion it's more like this:

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

If the field is Null or 50, then Continue Assessment
If the field is = or more than 50 ,then Benefit Recognized
If the field is 0, then nothing goes in the box

Blimey, if they could just confirm what they want ahead of time. sheesh!