Problems with percentages

[Guest]

I know this should have a simple fix, but I can't remember it. I have some fields that are storing percentages. When I enter a number greater than 1 I get 100% or 5500% etc. When I enter a decimal number less than one such as .25 it rounds to 0.0% What am I missing.

Scott

 

[Allen Browne]

1. Open your table in design view.

2. Select the problem field.

3. In the lower pane, change File Size from
Long Integer
to
Double

The integer types can only store whole numbers.
After the change, you will be able to get 25% by entering:
25%
or
.25

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I know this should have a simple fix, but I can't remember it. I have some

fields that are storing percentages. When I enter a number greater than 1 I
get 100% or 5500% etc. When I enter a decimal number less than one such as
..25 it rounds to 0.0% What am I missing.