Add % to Existing Number

[Hari]

Hi All,

How can show my filed with rounded number and with % in other field.

ex (0 = 0.00%
0.1 = 0.01%
2.5555 = 2.56%
5.666777 = 5.67%)

Please help

Regards
Hari.

 

[Allen Browne]

Set the Format property to Percent.

If you have existing data were 2.5 actually means 2.5%, use an Update query
to divide the field by 100.

If you use Access 2007 and you set the Format property of to Percent, the
percent sign is added for you automatically, so when you enter 2.5 it is
interpreted as 2.5%. If you are using an earlier version, use the code in
this link to automatically add the % sign for you so:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html