Terry,
i tried using round, but i hadn't considered in. Jos suggested ceiling which i have never heard of but it doing the trick. on another not have you seen http://www.liverpoolfc.tv/news/drilldown/N150508051107-1512.htm
Slán
~M

>Mark
>
>How about the ROUND() and INT() functions?
>
>Terry
>
>>hi all,
>>i have an few lines of code and i was just wondering if there was a neater way of doing it. in an application we store the area a box of tiles covers. when the user enters the area of the room, this figure is divided by the area the box covers and we get the number of boxes needed. sometimes this is 2.3 boxes which i want to round to 3, where the problem is, and sometimes it 2.6 and everything works out fine. is there a short way to always round up? i have code already doing it using mod etc, but i'm just wondering if there is a one liner, possibly an unlisted parameter or something.
>>Slán
>>~M