change long number to multiple fields

[trythis]

I have this number in my table in a field
abcd/6300/6300123/630012379999

I want this
field1...field2....field3
123.......7........9999

I only want the last 8 numbers seperated out.

Thank You for your help.
Tina

 

[pbaldy]

You can use the Mid() function to grab each group of characters.

 

[trythis]

I'm kinda new. I will research the Mid() function.

Thanks,
Tina