Percent format problem

A

Amy Blankenship

I have a table field I want to set up as a percentage. When I enter 70 in
it I get 700.00%. When I enter .7 in it, I get 100.00%.

Am I misunderstanding how percentage fields work? I just want 70% in the
field...

Thanks;

Amy
 
D

Duane Hookom

It looks like your field might be long integer or integer. If you want to
store a percentage, then you should use a double, single, currency, or
decimal field type.

I expect entering 70 would give you 7000.00% and not 700.00%. The number 1
is 100%. If you want 70%, enter its value as .7.
 
A

Amy Blankenship

Yes, I spotted that right after I posted. Changed it to a double and it
worked.

Thanks;

Amy
 
Top