目录

MS Access Format() 函数

❮上一节 ❮ MS Access 功能下一节❯

示例

将"Price" 列格式设置为货币：

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

亲自试一试 »

定义和用法

Format() 函数使用指定的格式格式化一个值。

语法

Format( value, format)

参数值

Parameter

Description

value

Required. The string 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
General Date	Shows value as a date based on the system settings
Long Date	Shows value as a date based on the system's long date settings
Medium Date	Shows value as a date based on the system's medium date settings
Short Date	Shows value as a date based on the system's short date settings
Long Time	Shows value as a date based on the system's long time settings
Medium Time	Shows value as a date based on the system's medium time settings
Short Time	Shows value as a date based on the system's short time settings

技术细节

工作于：	从 Access 2000

❮上一节 ❮ MS Access 功能下一节❯