How to round a number which has no decimal.I want to round the number to the nearest zero.
That is,if the last digit of the number is 0,then it should be as it is.If the last digit
is 1,2,3 or 4,then the number should be rounded of to the previous zero.(Eg. 704 to 700)
If the number ends in 5,6,7,8, or 9 then it should be rounded of to the next zero (Eg. 706 to 710)
In Excel, it is working like this.ROUND(Number,-1).In Access Help Function says the same logic.
But,when executing the same formula,it displays Error message.

Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer

Divide by 10
Remove decimal part (use INT() )
Multiply by 10 again


Cheers Ray

Dear Ray,
Thanks for the help with which we were able to sort out the problem.
But there was a small problem in your reply.Integer function removes the
decimals alltogether.In the process,it removes the digits after the
decimal point which are 5 or above (ie, 5to 9).Then,we cannot get the
higher zero (ie, 709 also becomes 700 and not 710). So we have used
the Round function to solve the problem after dividing the number by 10
(ie,round(number,0).Then we have multiplied by 10 to get our result
correctly.We are still searching for the answer to solve the problem
by applting the Round(number,-1) function since it solves the problem straightaway
and since it works without any problem in Excel.Thanks once again for your
help.It has helped us to think in another way which we have nit thought
so far.

Mohamed Mohiddin
Officer