MS Access Format() လုပ်ဆောင်ချက်
❮ MS Access လုပ်ဆောင်ချက်များ
ဥပမာ
"စျေးနှုန်း" ကော်လံကို ငွေကြေးအဖြစ် ပုံစံဖော်ပါ-
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 လုပ်ဆောင်ချက်များ