Fix

Return the integer value of a number:

SELECT Fix(756.43) AS FixNum;

Definition and Usage

The Fix() function returns the integer part of a number.

Fix(number)

Parameter	Description
number	Required: A numerical value

Works in:

From Access 2000

Retrieve the integer portion of the values in the “Price” column.

SELECT Fix(Price) AS FixNum FROM Products;