Percentages

[Gianna]

I have a field that needs to be a percentage, when I enter
35 it changes to 3500%, if I enter .35 it shows as 0%.

I just need it to show as and be entered as 35 to be 35%


Can someone help...

 

[Sean]

Matt,

In the 'table design view' you need to change the "Field Size" of your field
to either single or double depending on your need. Then you can enter your
percentage values in decimal form (0.20 = 20%).

I suspect that it currently says "Long Integer". Remember an integer is a
"whole number" e.g. 1, 2, 300, -976. A decimal is NOT an integer -- and
thus neither is a decimal.

Sean