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!


"David F Cox" wrote:

at a quick glance this looks to me like it resolves to:
IIf([txt_cumulamt7] BETWEEN 1 AND 49,"Benefit Recognized,"")


"chickalina" wrote in message
...
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!