Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    72

    Unanswered: ROUNDING Problem

    How do I round up a value ... say 14.035 to 14.04 using VB. It always seems to round down to 14.03.

  2. #2
    Join Date
    Jul 2003
    Posts
    25
    Have you tried changing the data type of your field from a number to currency? If you use the currency data type and set your format to fixed with 2 decimal places, your value will appear as 14.04 but 14.035 will be stored in the field. Currency is more accurate and can help prevent rounding off errors. For further information see Access Help: About data types and field sizes and then select Choosing between a Number or Currency field...tibbsy

  3. #3
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    139
    I'm not sure about it, but if you have a number like 14.035 it will be always rounded to 14.03. Instead if you have 14.036 it will be rounded to 14.04. You should check it!
    Marco
    ---Do not send e-mail---
    "New Big Bang Theory: God said unzip universe"

Posting Permissions

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