Int

Return the whole number part of a decimal value:

SELECT Int(756.43) AS IntNum;

Definition and Usage

The Int() function returns the integer part of a number. If the number is negative, it returns the largest integer less than or equal to the number.

Int(number)

Parameter	Description
number	Required: A numeric value

Works in:

From Access 2000

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

SELECT Int(Price) AS IntNum FROM Products;