bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Int() Function

Example

SELECT Int(756.43) AS IntNum;

Definition and Usage

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

Note

If number is negative, this function returns the first negative integer less than or equal to number .

Syntax

Int(
number
)

Parameter Values

ParameterDescription
numberRequired. A numeric value

Technical Details

Works in:From Access 2000

Previous

MS Access Format() Function

Next

MS Access Max() Function