Percentage Field

  • Thread starter Thread starter Karlos
  • Start date Start date
K

Karlos

Im trying to get a field in an access table to hold
percentages.

In the design, I have set the data type to number and the
format to percentage.

yet when i try to type in a percentage in datasheet view,
it doesnt seem to work.

If I type out 10 it returns 1000% but it I type 0.10 it
returns 0.00%. nothing seems to work (e.g .1 , 0.10%, 10%
etc)

Does anybody know why it doesnt work or what im doing
wrong????

Thanks in advance
 
Karlos

Access stores numbers in tables. You can format the display to show as
percentages, but it will still be a number being stored.

10 IS 1000%. And if your number's data type is integer, anything less than
1 will be lost when stored.

Good luck

Jeff Boyce
<Access MVP>
 
You would enter .1

It sounds as though the field size is set to Integer or Long Integer in
which case .1 will become 0. Change the field size to
single.
 
Back
Top