MS Access SQL help.
I'm trying to truncate a long string which contains 2 to 3 random sections with character. Each section is separated by a Foward Slash (/). Need to capture only the COMPANY NAME from the left of the field, TRANSACTION_NARR, as follow:
I tried using the following logic to create a calculated field but it only removes the 3rd section:
IIf([TRANSACTION_NARR] Is Not Null,(Left([TRANSACTION_NARR],(Len([TRANSACTION_NARR])-InStr(StrReverse([TRANSACTION_NARR]),"/")))),0)
Please provide full solution...greatly appreciated!