Results 1 to 3 of 3

Thread: split a number

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    split a number

    how can i split a number into two parts
    like take 12.8862 and put
    12 in one textbox and 8862 in another
    i'm using access 2000
    thanks for any help
    JerryC

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

    Re: split a number

    There's probably a better way, but this will work. [txtMyNumber] contains 12.8882 -- Int([txtMyNumber]) will return the integer value "12" and [txtMyNumber]-Int([txtMyNumber]) will return the remainder "0.8882"

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: split a number

    thanks
    worked like a charm
    JerryC

Posting Permissions

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