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!
|