RoundUp

[Bronte1226]

I need to be able to round up any number that has a decimal that is something other than 0. Excel has a function to do this, but it is not recognized in Access. Is there another function that will do this or a work around?

 

[PHV]

Something like this ?
RoundUpValue = Int(DecimalValue + 0.999999999)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[traingamer]

one way:

iif(int([yourfield]) = [yourfield], int([yourfield]), int([yourfield] + 1))

traingamer