SQL•SQL References

MS Access Fix() Function

Example

SELECT Fix(756.43) AS FixNum;

Definition and Usage

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

Syntax

Fix(
number
)

Parameter	Description
number	Required. A numeric value

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT Fix(756.43) AS FixNum;

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

Syntax

Fix(
number
)

Parameter	Description
number	Required. A numeric value

Works in:	From Access 2000