A9992736
12-27-2012, 06:37 PM
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.
=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.