Results 1 to 2 of 2

Thread: [RESOLVED] How to round the number for string data type field name?

Threaded View

  1. Feb 14th, 2008, 03:39 AM #1
    matrik02
    matrik02 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    Resolved [RESOLVED] How to round the number for string data type field name?

    I have problem here, I used text data type for all these field name. I don't know how to round these number. I got 3.4189189.. after calculating the value. How I can round these number to be like this 3.412 ?

    Code:
    Fields("Hasil Kasar (kg)").Value = Text2.Text
         Text3.Text = Val(Text2.Text) / 1000 / Label10.Caption
        .Fields("Purata Hasil Kasar (Tan/ha)").Value = Text3.Text
         Text4.Text = Text2.Text - (Text2.Text * 17) / 100
        .Fields("Hasil Bersih (-17 %)").Value = Text4.Text
         Text5.Text = Text3.Text - (Text3.Text * 17) / 100
        .Fields("Purata Hasil Bersih (Tan/ha)").Value = Text5.Text
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width