Access currency regular number 2 after integer

1. Let's take a look at the differences between these formats, as shown in the following table:

Settings
description
examples

regular numbers (default values) display the input numbers as they are. 3456.789
thousand separator is used for currency; For negative number, decimal, currency symbol and decimal point position, follow the settings in Windows control panel. ￥ 3457
the euro uses the euro symbol (#8364;), The currency symbol specified in Windows regional settings is not considered&# 8364; 3456.79
at least one digit will be displayed. For negative numbers, decimals, currency symbols and decimal places, follow the settings in the windows "control panel". 3456.79
the standard uses thousands separator; For negative numbers, decimal symbols, and decimal point positions, follow the settings specified in the windows locale. 3456.79
percent multiplied by 100 plus percent sign (%); For negative number, decimal, currency symbol and decimal point position, follow the settings in Windows control panel. 123.00%
the standard scientific counting method was used. 3.46E+03

2. Double type is OK

3.

Materials / tools: access

1. Open access and add some content to the form

4. N is the meaning of number. In (10, 2), 10 is the integer, 10 is the digit, 2 is the decimal, 2 is the digit.

5. It is estimated that the data type of the table on your computer is not set properly:
you can try this: open the design view of the table -- & gt; ① Data type: number. 2. In the General tab, the settings are as follows: field size: single precision; Format: fixed; Number of decimal places: 2

7. Currency: this type is a special type of numeric data type, which is equivalent to numeric field type with double precision attribute. When you enter data into the currency field, you do not need to type the RMB symbol and the comma at the thousand place. Access will automatically display the RMB symbol and comma, and add two decimal places to the currency field. When there are more than two decimal places, access will round the data. The accuracy is 15 digits to the left and 4 digits to the right of the decimal point.

8. Acccess does have this kind of situation. It is forced to add that symbol in the SQL statement of the program.

for example,
select '￥' + HB as hbfh from tblname
where Hb is the field name of your data table

9. In access, there are two functions for taking integer:
1. Fix function, with the format of fix (numerical data). The function is to take the nearest integer on the left side of the horizontal number axis
for example: fix (5.25) return value is 5
fix (- 5.25) return value is - 6
2, int function, the format is int (numerical data), the function is only to take the integer part of the value
for example, the return value of int (5.25) is 5
the return value of int (- 5.25) is - 5

10. Select currency directly from data type