>Hi Jim,
>
>So, with this in mind, why do we have to declare the number of decimals when defining a numeric in the table structure and why is not possible to enter numerics with floating points in the browse window.
>
Mace,
The short answer is , Because!
I just did some testing and found that with 5,2 the field accepts and stores a value of 12345, however with 5,0 the field accepts 23.45 but it stores 23 truncating the decimal portion.