Skip to content
Related Articles

Related Articles

Improve Article
Fix() and Format() Function in MS Access
  • Last Updated : 02 Sep, 2020

1. Fix() Function :
In MS Access, the fix() function returns the integer part of a number. In this function, a number will be pass as a parameter and it will return the integer part of that number.

Syntax :

Fix(number) 

Example-1 :

SELECT Fix(-75.43) AS FixNum;

Output –

FixNum
-75

Example-2 :



SELECT Fix(23.93) AS FixNum;

Output –

FixNum
23

2. Format() function :
In MS Access, the format function will return a number in a specified format. In this function, the value will be passed as the first parameter and the format will be pass as second parameter. And it will return the converted format.

FormatDescription
General NumberFor without thousand separators.
StandardFor thousand separators + two digits to the right of the decimal place and minimum one digit to the left of the decimal place.
PercentFor percent value.
ScientificFor scientific value.
FixedFor one digit to the left of the decimal place and two digits to the right of the decimal place.
CurrencyFor currency, with thousand separators and two decimal places.
Yes/NoIf value==0 then no otherwise yes.
True/FalseIf value==0 then True otherwise False.
On/OffIf value==0 then Off otherwise On.

Syntax :

Format(value, format) 

Example-1 :

SELECT Format(0.55, "Percent") 
AS FormattedPercentage;

Output –

FormattedPercentage
55.00%

Example-2 :

SELECT Format(0.0000000004500121424255, "Scientific") 
AS FormattedScientific;

Output –

FormattedScientific
4.50E-10
My Personal Notes arrow_drop_up
Recommended Articles
Page :