Wierd number format / percent error

J

jct

Hope this isn't a stupid question...Trying to set a table field to represent
a percentage, but can't get the desired results. I set it as Data Type -
Number with Formate as Percent and Decimal Places as 1. If I go to Table view
and type 3, I get 300.0%, not 3.0%. If I type .03 or .30, I get 0.0%. What am
I doing wrong?

I get similar results if I chose Format - General Number, with 2 decimal
places...

Thanks,
Janice
 
V

Van T. Dinh

It sounds to me that you have selected one of the whole number numeric size
(Long / Integer / Byte ...).

You need to select one of the sizes that allows decimal places like Double /
Single or Decimal.
 
J

jct

Double worked. Thanks Van.

Van T. Dinh said:
It sounds to me that you have selected one of the whole number numeric size
(Long / Integer / Byte ...).

You need to select one of the sizes that allows decimal places like Double /
Single or Decimal.
Click to expand...
 
Top