I fixed it myself. When the field is initially defined and numeric is selected as the type of field, the size of the field defaults to 10.2. All I needed to do was change the default to 10.4 and this solved my problem.
I have a field defined as numeric but when I change the decimal place to 4 instead of 2 I get 4 decimals but it seems to be rounding down and placing zeros in the last 2 decimal places. Example. Entered as 5.6785 is displayed & calculating as 5.6700.
Does anyone know how to fix this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.