I need help parsing out a value from a string in Access Query.
My field has
I need to parse out the customer number between "_" and ".pdf"..
The number can be bigger or smaller, but will always precede with the underscore and end with the period.
Is this possible within the access query ?