Fix() and Format() Function in MS Access

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
My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.