I want to have a query round numbers up to the nearest hundred. How do I do this? ivor
I Ivor Williams Dec 24, 2003 #1 I want to have a query round numbers up to the nearest hundred. How do I do this? ivor
A Allen Browne Dec 24, 2003 #2 The built-in Round() function (in Access 2000 and above) cannnot do that, but this one from Ken Getz can: http://www.mvps.org/access/modules/mdl0054.htm Rename the function to (say) MyRound so it does not fight with the built-in one, and use: MyRound([MyField], -2)
The built-in Round() function (in Access 2000 and above) cannnot do that, but this one from Ken Getz can: http://www.mvps.org/access/modules/mdl0054.htm Rename the function to (say) MyRound so it does not fight with the built-in one, and use: MyRound([MyField], -2)
