Open In App

Fix() and Format() Function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

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.

Format Description
General Number For without thousand separators.
Standard For thousand separators + two digits to the right of the decimal place and minimum one digit to the left of the decimal place.
Percent For percent value.
Scientific For scientific value.
Fixed For one digit to the left of the decimal place and two digits to the right of the decimal place.
Currency For currency, with thousand separators and two decimal places.
Yes/No If value==0 then no otherwise yes.
True/False If value==0 then True otherwise False.
On/Off If 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

Last Updated : 02 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads