Mround function

M

Mike Labosh

What is the MRound function (Excel) equivalent in Access 2002?

Since we're Access geeks, it might help us if you specify the purpose,
behavior and meaning of the return value of this MRound() function. Given
better information, folks in here are FAR more likely to realize what you
want and supply suggestions.
 
V

Van T. Dinh

There is no equivalent inbuilt function in Access. However, it can be
handled with simple expressions like (rounded multiple of 3 from Debug
Window):

?CLng(10/3)
3

?CLng(11/3)
4
 
Top