garyrobbins
asked on
Access Querry only part of a string
I am trying to build a function in access that would only select the last User Name. Seperate by a ²
So this
TTRA²TTRA²TTRA
OCRJMR²OCRJMR²GYEYE55
Would return
TTRA
GYEYE55
So this
TTRA²TTRA²TTRA
OCRJMR²OCRJMR²GYEYE55
Would return
TTRA
GYEYE55
ASKER
I am sorry Function might not be the right term. I need something like whats below not as part of a macro.
Right([Columnt Name],8)
The user names is not always the same length which is what is throwing me off.
Right([Columnt Name],8)
The user names is not always the same length which is what is throwing me off.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try this
mid([Column Name], InStrRev([Column Name], "²")+1)
mid([Column Name], InStrRev([Column Name], "²")+1)
ASKER
Perfect!!!! Thank you some much!
Open in new window