Solved: Report IIf statement

[A9992736]

Hi guys, I have problem trying to do this IIf statement:

=IIf([Account_No]="*201",[Account_No] & "For " & [Purchase_Price_Curr],[Account_No])

I want to check: If the last 3 digit of account number is 201 for example, then it would show something like 123-123456-201 For GBP. Please assist. Thanks.

[A9992736]

Solved:
=IIf(Right([Account_No],3)=201,[Account_No] & "For " & [Purchase_Price_Curr],[Account_No])