Rounding up a fraction

  • Thread starter Thread starter DC
  • Start date Start date
D

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
 
DC,

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

Ben
 
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
'====================================================
 
Back
Top