ACC: Currency Is Significant to Four Digits (92680)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
This article was previously published under Q92680 Novice: Requires knowledge of the user interface on single-user computers.
SUMMARY
When using the Currency data type within Visual Basic for Applications (or
Access Basic in versions 1.x and 2.0), be aware that numbers are
significant to four digits to the right of the decimal point.
MORE INFORMATION
The reason for this is that most financial information, such as mortgage
rates and stocks, require four digit precision.
Currency variables are stored as 64-bit numbers (8 bytes) in a two's
complement integer format and scaled by 10,000 to give a fixed-point
number with 15 digits to the left of the decimal point and 4 digits to the
right. This representation provides a range of -922,337,203,685,477.5808
to 922,337,203,685,477.5807. The Currency data type is extremely useful
for calculations involving money and for fixed-point calculations in which
accuracy is particularly important.
REFERENCES
For more information about the Currency data type, search for "data
types," and then "currency" using the Microsoft Access for Windows 95 Help
Index.
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kbinfo kbusage KB92680 |
|---|
|