Developer Forum

by **c2hhenppZ** » Sat, 24 Jan 2009 00:32:03

I am not familiar with VBA. Is there a way in an MS Access query
(expression) to get my results of a function to round DOWN? They currently
round up or down depending on the result. I need the result to always round
DOWN.
Thanks, Sharon

by MV » Sat, 24 Jan 2009 00:48:54

Try the following untested function.

Public Function fRoundDown (dblNumber As Double, _
Optional intPlaces As Integer) As Double
fRoundDown = -Fix(-dblNumber * 10 ^ intPlaces) / 10 ^ intPlaces
End Function

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

by **John W. Vi** » Sat, 24 Jan 2009 02:40:23

On Thu, 22 Jan 2009 07:32:03 -0800, shazzie

The Int() function returns the next lower integer: Int(3.1) = 3, Int(3.887) =
3. Note that this applies to negative numbers too - Int(-32.15) = -33.
--

John W. Vinson [MVP]

by **VHVvbm8gQy** » Sun, 01 Mar 2009 06:39:03

Dear Sir,

how about decimals ?
I cant believe that ms access doesnt have any function like rounddown as in
ms excel.

Tuono C.

Developer Forum

Round DOWN in Access

Round DOWN in Access

Round DOWN in Access

Round DOWN in Access

Round DOWN in Access