round function help
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.