Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    68

    Unanswered: update query question

    Hello, I have a field that I need updated. The data in the field is in the following format: "024840100". I need to update the data so that it displays like this: "0100-02484".

    Can anyone provide me the the syntax to use to make this change?

    Thank you very much,
    Grace

  2. #2
    Join Date
    Aug 2002
    Posts
    6
    If the format is fixed, you can try this:

    Assuming strX is 024840100:

    dim strA as string
    dim strB as string
    dim newStr string

    strA = right$(strX, 4)
    strB = left$(strX, 5)
    newStr = strA & "-" & strB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •