THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Format() Function

❮ MS Access Functions

Example

Format a numeric expression to percent:

SELECT Format(0.5, "Percent") AS FormattedNum;
Try it Yourself »

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;
Try it Yourself »

❮ MS Access Functions