Link to home
Start Free TrialLog in
Avatar of hkgal
hkgal

asked on

How do I locate the position of character in a string in Access?

I have a string in a field: "MS Steven, Middletown, Chicago, US"

How do I detect the position of last occuring ","? <--that one behind Chicago?
I know Instr function, but how do i detect in a reverse order?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

you will use
instrrev(str,"?")
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hkgal
hkgal

ASKER

NICE