> Dear all,

>

> Please help me with this one !

>

> I need to convert a figure (numeric) to the nearest 10, using round I suppose,

>

> For eg., I get an answer/total of 89,764 it should be converted to 89,770

>

> I have tried round(ggg,10) but it does not work...

>

> Thank you!

>

> Barney

You may use ROUND(), but it rounds to the nearest not to the upper tenth.

nxx=89764
? ROUND(nxx,-1)

gives 89760.

You can use a trick

? ROUND(nxx+5,-1)

who gives 89770

but, unfortunately, fails for nxx=89760 because it gives 89770.

So it be must more elaborated.

The final solution is :

? ROUND(IIF(MOD(nxx,10)=0,nxx,nxx+5),-1)

In conclusion, Mr. Stefan Wuebbe's solution is simpler and clearer

My respects