-
Solved: Report IIf statement
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.
-
Solved:
=IIf(Right([Account_No],3)=201,[Account_No] & "For " & [Purchase_Price_Curr],[Account_No])
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules