Removing characters from a text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example: K123456-mg
Example: K1234567-mg
I want to remove all characters before the "-" in this string. Some part
number have 7 characters before the "-", some have 8 and some have nine.

Your suggestions are very welcome.

I am an intermediate access user. Can this even be done in access or do I
need to learn vb?
 
Check out the Mid and InStr functions in help file. You can use them to do
what you seek.
 
Back
Top