THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Int() Function

❮ MS Access Functions

Example

Return the integer portion of a number:

SELECT Int(756.43) AS IntNum;
Try it Yourself »

Definition and Usage

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

Note: If the number is negative, this function will return the first negative number that is less than or equal to the number.

Syntax

Int(number)

Parameter Values

Parameter Description
number Required. A numeric value

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the integer portion of the "Price" column:

SELECT Int(Price) AS IntNum FROM Products;
Try it Yourself »

❮ MS Access Functions