MS Access Fix() Function

Return the integer part 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 numeric value

Works in:	From Access 2000

Return the integer part of the "Price" column:

SELECT Fix(Price) AS FixNum FROM Products;