MS Access Int() Function

Return the integer part of a number:

SELECT Int(756.43) AS IntNum;

Definition and Usage

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

Note: If number is negative, this function returns the first negative integer less than or equal to number.

Int( number)

Parameter	Description
number	Required. A numeric value

Works in:	From Access 2000

Return the integer part of the "Price" column:

SELECT Int(Price) AS IntNum FROM Products;