Rounding Down

[JoeShmoe]

Basically i've made a Select statement with cases like 0,1,2,3 ect. The problem is the thing im checking is often a decimal number.. how would i go about rounding it down no matter what the decimal?

Thanks in advance.

[asingh]

SELECT Int([Table1]![num]) AS num_int FROM Table1


where..num is my decimal number I am typecasting it into an integer

[OTWarrior]

doesn't "Int" round up though?

[akn112]

I believe changing it to an int concatenates everything to the left of the decimal place. so it rounds down

[OTWarrior]

Yep just tested it.
it does round down, my bad.

[TonyJollans]

Yes ..

Int returns the Integer part of a number
CInt converts it to an integer (and rounds it in the process)

[DarkSprout]

Place this in a module, and use instead of CInt or Int


Public Function DInt(n As Single) As Long
'returns only the value left of the decimal point
DInt = Left(Trim(str(n)), InStrRev(Trim(str(n)), "."))
End Function