Results 1 to 3 of 3

Thread: Numbers

  1. #1
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266

    Unanswered: Numbers

    I have a list of numbers of varying length. They vary from 3 digits to 15 digits in length. I need the last 4 digits, but am stuck for a solution. Grateful for any help.

  2. #2
    Join Date
    Jan 2003
    Posts
    10

    Re: Numbers

    Originally posted by DJN
    I have a list of numbers of varying length. They vary from 3 digits to 15 digits in length. I need the last 4 digits, but am stuck for a solution. Grateful for any help.
    Might try

    Val(Right(Str([field1]),4)) where field1 is your original number

  3. #3
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Thanks Dambros. Brain not in gear today!!

Posting Permissions

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