MS Access Fix() Function

Posted by

MS Access

Fix()

Function

Example

Return the integer part of a number:

SELECT Fix(756.43) AS FixNum;


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;