Delimit a field within an Access table

[whevans]

Hi,

New to the forum as a poster, but I've used it a bunch in the past to answer questions. Here is my issue:



I have a field of varying length and format. I want to update a separate field to be everything to the right of a forward slash "/" Can anyone help me with this? We'll call the field "Text ID" and an example of the contents would be "SDI 22532993/130". Also, the number of digits to the right of the "/" varies between 1 and 5 digits.

Thanks for any help you guys and gals can give.

-W

[pbaldy]

You can use the Mid() function, using the InStr() function to find the slash for the starting position.