Rounding to the nearest 10

[Benny]

I have a query that returns a value of 4342

I would like to round it to the nearest 10 ie 4340

If the value was 4346 =4350

 

[Dennis]

NewNum = Int(OldNum / 10 + .5) * 10

 

[Jeff Boyce]

Benny

If you set a reference to Excel, you can use the RoundWorksheet() function.

If you don't, you could:

 

[Benny]

Dear Dennis,

Thanks heaps. I've spent bloody ages trying to find out the answer.

You've made a disgruntled user very happy.

Regards,

Ben