Last updated: August 26, 2026.
The Fix function removes the fractional part of a number by truncating toward zero.
Syntax
Fix(number)| Argument | Description |
|---|---|
number | Numeric expression |
Examples
Fix(8.9) ' 8
Fix(-8.9) ' -8
Int(-8.9) ' -9Fix and Int differ for negative numbers: Fix truncates toward zero, while Int rounds downward.
See Microsoft’s Access function reference for related expression functions.
