select cast(round(x-0.01,0) as int
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)