As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/

Microsoft Access Help

AnteCantelopeAnteCantelope Registered User regular
edited January 2011 in Help / Advice Forum
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.

AnteCantelope on

Posts

  • TwoQuestionsTwoQuestions Registered User regular
    edited January 2011
    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.

    TwoQuestions on
    steam_sig.png
  • tralevtralev Registered User regular
    edited January 2011
    I'd create a new field, then run an update query with this:
    left(RIGHT([Field],7),2) & "-" & right([Field],5)

    tralev on
    Steam: tralev PS3: GeekMcD
Sign In or Register to comment.