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

Save