Percentage

[John]

Hi,
My table has a field called "Discount".
The field is set to Number and the format set to Percent.
When I put in the number "1" I get 100% correct!
when I put in the number "0.10" I should get 10% but I get 0%. I need to be
able to achieve 10%.

Any Ideas?

Kind Regards

John

 

[Allen Browne]

Open the table in design view.
Select the Discount field.
Change the Field Size property to:
Double.

The integer types can store whole numbers only. Double works with fractions.

You may also be interested in this article:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html
It explains how, in a form, you can type just 10 and have it interpreted as
10%. (Access 2007 will do that for you without the code.)

 

[John]

Perfect
Thanks Allen

Kind Regards

John

Open the table in design view.
Select the Discount field.
Change the Field Size property to:
Double.

The integer types can store whole numbers only. Double works with
fractions.

You may also be interested in this article:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html
It explains how, in a form, you can type just 10 and have it interpreted
as 10%. (Access 2007 will do that for you without the code.)