Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    recoding help required (2000 French)

    Need help in recoding text data .
    Normally my "region" variable is coded in text format two characters in length 01 02 03 ..... 20, but someone drop the ball and the region code for this year's data is coded without the zero for region numbers below ten. I need to look at the length of the field and add a "0" if the field length is only 1 character long. Thus 1 would become 01 and 2 would become 02
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: recoding help required (2000 French)

    You can use an update query, in the region field column, set critera to: Len([region])=1 and in the Update To: section -- "0"+[Region]

Posting Permissions

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