Microsoft Access Help

Ante

I'm trying to set up a database for work, and I'm sure there are ways to do this faster. One thing I'd like to know in particular: is there any way to have one field which contains, for instance, 1S4333A25R8RFRY2, and another that pulls out the last 7 characters and chucks a hyphen before the last 5, giving R8-RFRY2? Doing it manually hundreds of times is going to be pretty sucky.
Using Microsoft Access 2007.

Thanks a lot.

TwoQuestions

There's a ton of string functions that come with Microsoft Access. I haven't worked with it in a while, but a quick trip through the help docs should reveal what you need.

tralev

I'd create a new field, then run an update query with this:
left(RIGHT([Field],7),2) & "-" & right([Field],5)