>>Hi,
>>
>>What about:
>>
>>

Round(CSng(nValue)+0.5)

>>
>>Just 2 cents.
>
>
>Well, if nValue is 4.0, that still returns 5.0. Which, I would assume, is not the desired result.

Hi Vin,

I just tried in the both VB 6.0 and in VBA for Access 2000 and Round(Csng(4)+0.5) returnes 4.
Please check it out and correct me if I missed anything.