Is there a Round function

[ibvma]

This should be an easy one.

Is there a function that will round a dollar figure to the nearest $100. I know there is one in Excel but I need one to work in an Access form.

thanks in advance

 

[jjonesal]

Yes.

Round(2.25,1) would round 2.25 to one decimal place.


Try: Round([yourfield],0) J. Jones
jjones@cybrtyme.com

 

[danvlas]

Function DnRound(Number As Double, decimals As Integer) As Double
DnRound = Int(Number * 10 ^ decimals + 0.5) / 10 ^ decimals
End Function

DnRound(449, -2) = 400
DnRound(450, -2) = 500

Is that what you need?

Dan