Rounding up a fraction

[DC]

How can I recreate the Excel Roundup function so that, for example,
0.29899998 becomes 0.299 to 6dp or 0.01434999 becomes 0.014350 to 6dp.

Thanks

 

[Ben]

DC,

There is a round function in Access VBA and you can use it in Access
queries, in SQL view

Ben

 

[DC]

Is there a way of doing it without code?

DC,

There is a round function in Access VBA and you can use it in Access
queries, in SQL view

Ben

 

[John Spencer]

No, you are going to have to use some kind of function to do this.

You don't have to use vba round function. Especially since it does not
round up, it rounds. If your numbers are always positive then you can
use something like the following to round up.

-Int(-x * 100000) / 100000


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================