Show percentage sign in results?

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?

TKM wrote:

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?


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\%

--
Marsh
MVP [MS Access]

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

"Marshall Barton" wrote:

TKM wrote:

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?


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\%

--
Marsh
MVP [MS Access]

If you might have a lot of decimal places to the right, then
use:
0.########\%
or
0.########%
depending on what your number represents.
--
Marsh
MVP [MS Access]


TKM wrote:
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%


"Marshall Barton" wrote:
TKM wrote:
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?


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\%