Trimming characters

[Access_help_rob]

Hey there here is what im trying to do that i need help with.
I want to check my stock code field check the 2nd from last character, IF it equals a / then remove last 2 characters, else remove last 3. Can anybody help me with this code and where i will put it?
thanx
rob

 

[ColinEssex]

Don't post the same question in different forums. This is also posted in "General".

Col