Add % to Existing Number

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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Hari" Hari @discussions.microsoft.com wrote in message
...
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%)