Round function is rounding down the numbers

Question

hi

i have a number like 182.5 and i used round function like this

Round(([totals].[mark]+[totals2].[mark])/2)

then i get 182 but what if i want to get 183 what should i type ?

thanks

Answer 1

The Round function in Access rounds numbers ending in .5 to the nearest even number:

181.5 and 182.5 become 182

183.5 and 184.5 become 184

etc.

You can use

Int(([totals].[mark]+[totals2].[mark])/2+0.5)

to always round numbers ending in .5 upwards.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Thank you very much :D