Percentage Field

[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

 

[Jeff Boyce]

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>

 

[Guest]

So is there an answer?

i know 10 is 1000% but how do I display 10%.

 

[Joan Wild]

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.