percent problems

C

Carolyn

I have a database with several percentages. When creating the table, I
specify number, and percent with no decimals. When I go to enter 50%, for
example, I type .5, but it always goes back to 0%. If I enter 50, it will say
500%. I know that it multiplies the number by 100, but I don't understand why
it won't accept .5 as 50%. I have looked in help, I have searched the site,
and I have even looked it up in my Access book, but I am having no luck. Does
anyone know what I am doing wrong and how to fix it? Please help!
 
V

Van T. Dinh

You probably specified the Field Size of Long or Integer which can only
accept whole number, not fractional number. The Percent you specified is
mere a Format which tells Access how to display the number.

Change the Field Size to either Single or Double.
 
C

Carolyn

Thank you for your help. I will go and try that. It was really bothering me,
and I appreciate your response to my question.
 
Top