THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Fix() Function

❮ MS Access Functions

Example

Return the integer portion of a number:

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

Definition and Usage

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

Syntax

Fix(number)

Parameter Values

Parameter Description
number Required. A numeric value

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the integer portion of the "Price" column:

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

❮ MS Access Functions