Wierd number format / percent error

[Guest]

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

 

[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.

 

[Guest]

Double worked. Thanks Van.

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.