Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replace Characters at Start of string (2003)

    Hi folks, I have a field of Ids, some of which begin with either 0 or 00 in order to lengthen the numbers to a 6 digit field. For another purpose I need the fields to show their actual numeric such as 4076 instead of 004076 or 14076 instead of 014076. Can anyone help?

    TVM Ina

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Replace Characters at Start of string (2003)

    Try Val([FieldName]) with the correct field name substituted.

Posting Permissions

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