Function: Int

Description

Returns the integer portion of a number.

Syntax

Int(number)

Arguments

number can be a constant, a numeric field, an expression that results in a number or a function that returns a number.

Return value

This function returns a number.

Calculated field example

If the Price field contained the value 10.99, the following calculated field expression would return the number 10 (the integer portion of the field's value): Int(Price)

Filter/Find example

Records with a Price field value of 10.99, 10.02 or 10 can be selected or found using the expression: Int(Price)=10