MS Access Format() Function

Posted by

MS Access

Format()

Function

Example

Format a numeric expression to percent:

SELECT Format(0.5, “Percent”) AS FormattedNum;


Definition and Usage

The Format() function formats a numeric value with the specified format.

Syntax

Format(

value

,

format

)

Parameter Values

Parameter Description

value
Required. The numeric value to format

format
Optional. The format to to use.

Format Description
General Number Indicates a number, without thousand separators
Currency Indicates currency, with thousand separators and two decimal places
Fixed Shows minimum one digit to the left of the decimal place and two digits to the right of the decimal place
Standard Shows the thousand separators + minimum one digit to the left of the decimal place, and two digits to the right of the decimal place
Percent Shows a percent value (with percent sign) and two digits to the right of the decimal place
Scientific Indicates scientific notation
Yes/No Shows No if

value

= 0 and Yes if

value

<> 0
True/False Shows False if

value

= 0 and True if

value

<> 0
On/Off Shows Off if

value

= 0 and On if

value

<> 0

Technical Details

Works in: From Access 2000

More Examples

Example

Format the “Price” column to currency:

SELECT Format(Price, “Currency”) AS FormattedPrice
FROM Products;