Trying to extract text from access table...field info looks like this:
Accrual Available Balance
-64.0(+40.08p)
0.0(+13.8p)
0.0(+15.33p)
Need to extract the data between the '+' and the 'p'. And not fixed placement. I tried the following formula:
Right([Accrual Available Balance],Len([Accrual Available Balance])-InStr([Accrual Available Balance],"+")) Left([Accrual Available Balance],Len([Accrual Available Balance]) + InStr([Accrual Available Balance],"p"))
and kept getting an error that read 'The expression you entered contains invalid syntax, you may have entered an operand without an operator'.
Can someone please help!!??!!