Quote: The Microsoft Access Round function returns a number rounded to a specified number of decimal places. However, the Round function behaves a little peculiar and uses something commonly referred to as bankers rounding. So before using this function, please read the following: The Round function utilizes round-to-even logic. If the expression that you are rounding ends with a 5, the Round function will round the expression so that the last digit is an even number.
Round
select cast(round(x-0.01,0) as int
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)