Like operand in Iif Or expression

[Hwyn9a]

Hello, I was wondering if anyone can point me in the right direction, I'm trying to simplify the following expression ( which works fine ) by using "Like" "Bank account" and Like "Received" as those words appear in all the criteria, but I haven't had any success.




Expr1: IIf([Type]="Add Funds from a Bank Account" Or [Type]="Withdraw Funds faster to a bank account" Or [Type]="Withdraw Funds to a Bank Account","Bank Funds",IIf([Type]="Payment Received" Or [Type]="Mobile Payment Received" Or [Type]="Fast Payment Received","Funds Received","Check"))


Regards Robert

[orange]

Try

IIf([typ] Like "*Bank Account*", "Bank Funds", IIf([typ] Like "*Received*", "Funds Received", "Check"))

I changed your Type to Typ for demo.

[Hwyn9a]

Thank you very very much, Orange! I tried and tried and tried to resolve it before i sent my first post and it was a silly syntax error that messed me up, you make it look so easy i'm in awe.
Thanks for resolving my issue