Results 1 to 2 of 2

Thread: rounding

  1. #1
    Join Date
    Jan 2004

    Unanswered: rounding

    MS Access rounds 5's to the nearest even number, for example 1.5 rounds to 2, 2.5 rounds to 2. It is possible to implement a "5's rounding up" function?

  2. #2
    Join Date
    Dec 2003
    Toronto, Ont. Canada

    Re: rounding

    Good Morning...

    I found this in Access Help...
    When the fractional part is exactly 0.5, CInt and CLng always round it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2. CInt and CLng differ from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. Also, Fix and Int always return a value of the same type as is passed in.
    Sounds to me like you should use CInt() or CLng() and you'll get the results you are looking for...


Posting Permissions

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