Nested IIf

[OMS]

Hi,

I think this is easy but not for me. If Field1 contains certain text i.e.
Ugly data or Bad data it should be left out of final result.

Example: Field1 Field2
Field3
Record1) Ugly data Keep always
Keep always also
Record2) Good data Keep always
Keep always also
Record3) Bad data Keep always
Keep always also

Result: 1) Keep always, keep always also
Result: 2) Good data, Keep always, Keep always also
Result: 3) Keep always, keep always also

This is what I have. I know it doesn't work so stop laughing ;-)

(IIf([Field1],"","Ugly data")) & (Trim([Field2]) & (Trim([Field3])

Field1 always comes back with no data. Want to nest IIf for Bad data also.

Thanks,
OMS

 

[OMS]

Hi,

Forget it I think I solved it...

Expression: (IIf([Field1]="Ugly data","",(Trim([Field1]))) & (Trim([Field2])
& (Trim([Field3]) & (Trim([Field4]) & (Trim([Field5]))))))

Thanks anyway. Hope someone else can use this.

OMS