Percent entry in Access 2003

[Guest]

I have a number field formatted as percent. I want to add 5%. Whenever I do
the screen shows 0. It seems to depend on whether I clear the entire field.
Leaving the 0% in the field and entering 5 in front of the 0 turns to 0 but
if I clear the field and enter 5 it shows 500%. Anyone have any ideas?

 

[Duane Hookom]

It seems your number field is Integer or Long Integer rather than Double or
Single or Decimal. Check the design of your table/field.

 

[Guest]

The format only controls how the data is displayed, so 5% is just the
presentation of the underlying value of 0.05, which is what you'd have to
enter in the field. Alternatively if this field stores something like a
discount rate or tax rate etc. you could store the value as the percentage ,
i.e. 5 and when using this in computations divide it by 100, so to compute
the gross price from NetPrice and TaxRate would be:

NetPrice + (NetPrice*TaxRate/100)

To format the percentage value stored as the percentage rather than a
fractional value and format it with two decimal places and the percent sign
you'd use a format of "0.00\%".

Ken Sheridan
Stafford, England