Is the FLOOR() or CEILING() SQL function available in Access? 1

[kchan]

Hi

I am wondering if the function FLOOR() or CEILING() is available in Access, I am trying to create a SQL query which will round down a number like 2.88 to the integer 2. The round() function is useless. Also is there a function in Access where it will return the integer portion of a division and discards the remainder

 

[PHV]

Use the \ operator for integral division.
Use the Int function to get the integral part of a decimal number.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244