Access Data Conversion Problems

Data conversion that may be used when using the database: type conversion Han number: function return type expression parameter range CBool any valid string or value expression. CByteByte0-255. CCurCurrency-922, 337,203,685,477.5808 to 922,337,203,685,477.5807. CDateDate any valid date expression

Data conversion that may be used when using the database: type conversion Han number: function return type expression parameter range CBool any valid string or value expression. CByte Byte 0 to 255. CCur Currency-922,337,203,685,477.5808 to 922,337,203,685,477.5807. CDate any valid Date expression

Data conversion that may be used when using the database:

Number of types to be converted:

Function return type expression parameter range

CBool any valid string or numeric expression.

CByte Byte 0 to 255.

CCur Currency-922,337,203,685,477.5808 to 922,337,203,685,477.5807.

CDate any valid Date expression.

CDbl Double negative number from-1.79769313486232E308 to-4.94065645841247E-324; positive number from 4.94065645841247E-324 to 1.79769313486232E308.

CDec Decimal zero ratio value, that is, no Decimal point

+ //-79,228,162,514,264,337,593,543,950,335. For the 28-digit decimal value, the range is

+/-7.9228162514264337593543950335; the minimum possible non-zero value may be 0.0000000000000000000000000001.

CInt Integer-32,768 to 32,767, rounded to the decimal part.

CLng Long-2,147,483,648 to 2,147,483,647, rounded to the decimal part.

The negative CSng Single number is-3.402823E38 to-1.401298E-45, and the positive number is 1.401298E-45 to 3.402823E38.

CStr String returns Cstr based on the expression parameter.

If CVar Variant is a value, the range is the same as that of Double. If it is not a value, the range is the same as that of String.