Mround function

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND 3
MRound 7
MROUND 1
Rounding Numbers 1
Round to nearest specific number 6
MROUND 4
Access Function like Excel Mround function? 3
MROUND 3

Back
Top