entering percentages in table

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

Guest

I have been away from MS Access for quite a few years and am starting over on
my skills. I have created a field in a table that is for whole number
percentages from 1 to 100, but when I enter any whole number, two zeros are
automatically added, so 70% becomes 7000%.

It's probably obvious to most of you, so perhaps someone could jog these
frozen brain cells.
 
In Access the percent data type is expected to be a value between 0 and 1.
You'll need to either divide your field value by 100 or change how the value
is being stored.

Carl Rapson
 
Percent is a fraction - 50% equals half or 0.5 but is displayed as a whole
number. So to enter 70% your field must be able to handle fractions and you
would enter .7 for display of 70&.
 
Back
Top