Access Int Function

Last updated: August 26, 2026.

The Int function returns the greatest integer less than or equal to a number.

Syntax

Int(number)
ArgumentDescription
numberNumeric expression

Examples

Int(8.9)       ' 8
Int(-8.9)      ' -9
Fix(-8.9)      ' -8

For negative numbers, Int rounds downward while Fix truncates toward zero. Choose the function that matches the required rule.

See Microsoft’s Access function reference for related expression functions.

admin

admin

Leave a Reply

Your email address will not be published.