Percentage Field Trouble 1

[rlh777]

I have a table called tbl_Percentage. The property is set as a Number field, as an Integer, with a format of Percentage. Regardless of what I enter into the field, it multiplies by 100 and returns a very high value. If I enter one, I get 100%. I would like a table that lists percentages starting with 0% thru 100% increasing in 10% increments. HELP!

 

[beetee]

A percentage, by definition, is a number that is less than 1. You cannot have an integer (or long) percentage. Any percentages must be double.

If you wish a table of percentages increasing by 10%, you would make a table with a field of type double, with values in the form .1, .2, .3 ... 1.0

 

[rlh777]

THANKS SO MUCH! I thought I had tried that before, but obviously not. Works great!

 

[beetee]

Any time.

You know, I think that one statement about percentages was a bit draconian. Of course percentages can be larger than 100%; but if you want percentages to be less than 100%, you need real numbers, not integers.