Round function produces wrong answers in Access 1

[ashfaque1]

I have used round function in a DB. but it gives results as follows :

function returns
round(1.5) 2
round(2.5) 2
round(3.5) 4
round(12.5) 12
round(13.5) 14
.
.
.
.

I could not understand where the figure contains value 2 the .5 is not rounded to next digit but a previous one.

Could anybody suggest me the solution of this problem/bug.

 

[dhulbert]

Round will use standard rounding practice and will therefore round .5 to the nearese Even number so 2.5 goes to 2 but 3.5 goes to 4

 

[jrbarnett]

A workaround is to use the Format function:

Format (2.5, "#&quot

returns 3
but format (2.49, "#&quot
returns 2

John

 

[ashfaque1]

Mr.John, the format functions does not work as you specified.
I am developing a Payroll Software, and I am using MS Excel to make the time sheet of an employee. My calculation in excel does not match to the calculation in Access. Because (as per above) access round function is rounding to the nearest even number.

 

[dhulbert]

Ashfaque1, What function are you using in Excel, The round function uses the same standard rounding as Access (i.e. nearest even number) but there are roundup and rounddown funstions, are you using one of these instead?

 

[dhulbert]

No I'm lying it doesn't, ignore that last post.......

 

[DonQuichote]

There are two methods of rounding:

The european method: .5 or more is rounded up

The american method .5 is rounded towards the nearest even number.

It seems access uses the american method, or it might be a local setting, I don't know. However, the formula

Int(x+0.5)

rounds x according to the european method.

Best regards

 

[JoyInOK]

Thanks DonQuichote, that's just what I was looking for. Watch out for those windmills.