Access number and currency

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

3. 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.

4. 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

5. You have access to the access to the 3333333333333333333333333 /> datetime adDate
decimal adNumeric
float adDouble
int adInteger
money adCurrency
varBinary adVarBinary
varChar adVarChar

6. The text field in the database table allows you to enter numbers, but the system will process these numbers according to the text. If you need to calculate the numbers in the text field, you need to convert them into numbers. For the currency type field, you cannot enter the currency unit, but you can enter the currency symbol, such as & # 165$ The regional settings of the operating system shall prevail. If you really need to record the currency unit, it is recommended to add a text field to identify the currency unit.

7. Currency type is an accurate number with up to 4 decimal places and many integers
the reason why currency type is set is for accurate calculation of digital amount

it can receive all kinds of number types, but it is not recommended to use floating-point type to assign value to it. It is better to use all kinds of integer type or single and double numeric types to assign value to it, which are all accurate values

as for the currency unit, there is no unit concept in the database. If you understand this field as RMB, it is RMB. If you understand it as US dollar, it is US dollar
if conversion is needed, a dollar field, an exchange rate field or a currency type field should be added.

8.

In the design view of the table, you can find the currency field,

in the format below, you can find & amp; yen; The format of the symbol

then you need to check the regional and language settings in the control panel. There is a currency format, which must be Chinese or Chinese.

9. It is estimated that there is non monetary data in this column of the table

consider deleting the existing data first, and then re inserting the column data

10. ' Total order statistics
rs.open " select Sum(y_ money) as sumval from nnt_ yewu", conn,1,1
zongjine=rs(" sumval")
rs.Close

I've removed your brackets and conditions, so if you get them, it's your grammar problem. It's probably a matter of brackets and double quotes.