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.
|
Technical Details
Works in: | From Access 2000 |
---|
More Examples
Example
Format the “Price” column to currency:
SELECT Format(Price, “Currency”) AS FormattedPrice
FROM Products;