Show percentage sign in results?

T

TKM

I am linked to a SQL DB. It is set up as a Numbert datatype and double field
size. I need to get my report to show a percentage with one decimal to the
left. I have the field on the report set up as a general number auto decimal
places. How come it does not show the % on the report but it does show the
correct placement of the decimal?
 
M

Marshall Barton

TKM said:
I am linked to a SQL DB. It is set up as a Numbert datatype and double field
size. I need to get my report to show a percentage with one decimal to the
left. I have the field on the report set up as a general number auto decimal
places. How come it does not show the % on the report but it does show the
correct placement of the decimal?
Click to expand...


Percent is not a field type so you need to tell Access that
you want the % added. If your number is .25 for 25%, then
set the text box's Format propert to
0%
If your number is 25 for 25% then set the Format property to
0\%
 
T

TKM

Marshall,

If I never know how many digits there will be but do know it will have one
decimal to the left. How would I set that in the format section. Such as
0.0626%

Thank you for your help
 
M

Marshall Barton

If you might have a lot of decimal places to the right, then
use:
0.########\%
or
0.########%
depending on what your number represents.
 
Top