Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: Formating Numbers

    I have a 15 digit number that need to format it where it drops off the first 4 number. Example 78900101134345 need it to be 0101134345. I am using Access 2k.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    RIGHT(strNumber, Len(strNumber)-4)

    You could replace "Len(strNumber) - 4" with 11 if you're confident that it
    will ALWAYS be a 15 digit number
    Inspiration Through Fermentation

  3. #3
    Join Date
    Nov 2004
    Posts
    2
    Thanks for the responce but if I just do Right([feild],11) does exactly what I need.

Posting Permissions

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