Problems with percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.

Scott said:
I know this should have a simple fix, but I can't remember it. I have some
Click to expand...
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.
 
Back
Top