If you work with numeral values in your database, Access will make a basic distinction between saved values and displayed values in queries, tables and forms. Currency figures for instance, are often rounded and displayed to the whole cent, however they are saved as exact values. This difference may become a little confusing, especially when you’re making calculations. In this Special Topic we will show you what to pay attention to when saving and displaying numeral values.
To acces the videos for this Special Topic you must have subscribed to Access !
Access 2016
Precision and Display of Numbers:
In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.
(10 Min.)
Access 2013
Precision and Display of Numbers:
In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.
(10 Min.)
Access 2010
Precision and Display of Numbers:
In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.
(10 Min.)
Access 2007
Precision and Display of Numbers:
In this film we explain the relation between a field data type and the precision of the displayed and saved values. Also we will show you how to adapt the displayed values for example to rounded values.
(10 Min.)
Home
Special Topics
