Roundup Function in Excel - Access Equivalent? 1

[Musgrove42]

Does anyone know how to replicate the roundup function of Excel in Access? Im new at using Access and was wondering if anyone knows how to do it without using VBA. ALl I want to have is a function that makes any number with a decimal round up to the nearerst integer. Thanks!!!

 

[LittleSmudge]

So in Excel you would use

x = RoundUp(y,2)


In Access there is no Up / Down option so you need

x = Round( y + 0.5 , 2 )

Or If you are just rounding to integer values ( Dp = 0 ) then you could use

x = Int( y + 1 )

Because Int just strips off the fraction part ( Equivalent the RoundDown )


If Y can be negative then look carefully at the difference between Int and Fix - See Help files for a full description.




'ope-that'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Musgrove42]

Thanks - got it sorted! My values can be negative as well - so it complicates things. Thanks for your help