Rounding Down

[Don]

Is there a way to round a number down, in Access 2007, on a report? I think
I've done this before but I can't find that old database to check my work.

 

[OssieMac]

Hi Don,

Do you mean round down to a whole number. If so then Int(Number) will give
you the whole number.

However, if you want to round down say 5.67 to 5.6 then = Int(5.67*10)/10

 

[Brian]

Round(BaseNumber,DecimalPlaces)

Round (10.675,2) produces 10.68

Dim ABC as Single
ABC = 9.12345
Round(ABC,3) produces 9.123

 

[OssieMac]

Hi Brian,

Don's question was to round a number down. The round function rounds to the
nearest which can be up or down based on the digit immediately after the
number of decimal places parameter in the function. (5 and above rounds up.)

 

[Brian]

Sorry. Thank you. I should have clarified that I was trying to address the
possible ambiguity that I have had a couple of times from users. On occasion,
I have had someone use the term "round down" and upon clarification, I find
out that they really mean to reduce the number of decimal places, or regular
rounding.