Real fields
Real fields accept and contain floating-point numbers, which are useful for displaying very small and very large numbers. You can use real fields to process statistical information in reports.
For real fields, the representation in the database keeps a maximum of ten digits of data. After ten digits, the number is rounded, and the succeeding digits are ignored.
For example,
If you enter 12345.090009 | the value after submit is 12345.090010. |
If you enter 1234567.090099 | the value after submit is 1234567.090000. (The last three digits are ignored because the rounded answer comes after the tenth position.) |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*