percent problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Thank you for your help. I will go and try that. It was really bothering me,
and I appreciate your response to my question.
 
Back
Top