string question

[Victoria]

let's say i have a textbox holding the value 12ah6/6SQ61. I need a function
that will output the string before the /, and another that outputs the string
after the /. How do i do this?

thanks in advance
Victoria

 

[fredg]

let's say i have a textbox holding the value 12ah6/6SQ61. I need a function
that will output the string before the /, and another that outputs the string
after the /. How do i do this?

thanks in advance
Victoria

Before = Left([Fieldname],InStr([FieldName],"/")-1)
After = Mid([Fieldname],InStr([FieldName],"/")+1)