THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Fix() Function

❮ MS Access Functions

Example

Return the integer part of a number:

SELECT Fix(756.43) AS FixNum;
Try it Yourself »

Definition and Usage

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

Syntax

Fix(number)

Parameter Values

Parameter Description
number Required. A numeric value

Technical Details

Works in: From Access 2000

More Examples

Example

Return the integer part of the "Price" column:

SELECT Fix(Price) AS FixNum FROM Products;
Try it Yourself »

❮ MS Access Functions