Rounding double data type

[Charles Tam]

From Access code, how do I round to the nearest integer given a double data
type?
E.g. #1 round "15.5" to 16
E.g. #2 round "15.4" to 15

 

[Ken Snell [MVP]]

CInt(YourDoubleNumber)

 

[Paul Overway]

Cint doesn't round numbers properly, i.e., Cint(2.5)=2, Cint(3.5)=4, etc.
Better to use something like this...

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

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com

 

[Ken Snell [MVP]]

"proper" is in the eye of the beholder... < g > I'd overlooked the
"banker's rounding" discussions....

It works the way I always do rounding.. < g >