Math calculation going wrong...or am I crazy?

[Guest]

Hello to all! I have a field defined on a form as 'standard' number with no
decimals. The formula for the field is:
=IIf([Week6Total]>0,(Round(([Wk5AdjScore]+[Wk6AdjScore])/2,0)),0)
The values are as follows:
Week6Total = 277
Wk5AdjScore = 276
Wk6AdjScore=277
276+277=553
553/2=276.5
Rounded up should be 277. Correct? The form calculates a 276! I have
tried to change the field to 'general' number, tried to increase the number
of decimals, both of which show me that the calculated value is 276.5.

I have the same formula calculating other fields and it seems to work fine.
Not sure where things went wrong. Any help?

Thanks,
Jeff

 

[Guest]

I found my answer, MS Access uses 'Bankers Rounding'. I don't like the
answer, but we will have to deal with it.

Sorry for the duplicate post!
Thanks,
Jeff

 

[Dirk Goldgar]

I found my answer, MS Access uses 'Bankers Rounding'. I don't like
the answer, but we will have to deal with it.

You can create your own rounding function that rounds the way you want.
For example,

http://www.mvps.org/access/modules/mdl0054.htm