I have a table with a field containing a percentage number. e.g. 0.04256
In form view it shows all the decimal places required to show the exact figure e.g. 0.04256
However when the field is shown in a table, the percent is rounded to the nearest percent. e.g. 0.04 or 4%
I want the table to show the exact number. e.g. 0.04256 or 4.256%
I have tried to figure it out as I am sure it can be done, but have been unsuccessful.
Can someone help?
Thanks in advance.