The point I am making, is that I have a variable containing the sum, and I want that result rounded to one decimal place (9.5), I then want to issue ROUND() on this variable ROUND(nVar,0) to give me 10. But ROUND() insists on knocking the decimal places back to 9.46.

It's not the mathmatical side of it that bothers me, it's the fact that I want ROUND() to round 9.5 and not 9.46.