entering percentages in table

[Galen Dean]

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.

 

[Carl Rapson]

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

 

[KARL DEWEY]

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

 

[Carl Rapson]

Right, thanks. I was thinking of the Format of the control on the form.

Carl Rapson