entering percentages in table

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

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
 
G

Guest

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

Jamie Collins

In Access the percent data type is expected to be a value between 0 and 1.
Click to expand...

Misstatement, methinks. There is no percent data type I know of.

Jamie.

--
 
C

Carl Rapson

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

Carl Rapson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent duplicate groups of records in a table 1
percentages... 2
Frogs in the pond - Display percentages not numbers 6
Frogs in the pond - percentages not numbers 1
How to distribute/spread/map cost of project across different year 3
Calculating goal attainment 1
Automatically creating records in one table based on values in another table 1
Entering DATEs in EXCEL should not require use of "/" slashes. 1

Top