Percentage format

[borris]

hi all,

this is probably a very stupid question to you guys but it is driving me
nuts:-

i am trying to create a field that allows me to enter a number as a
percentage. in table design, i set the data type to number and then set the
format to percent.

however, when i then go in the table and enter, for example, 5 it change to
500%. if i type 0.05 or 0.5 it goes to 0%. if i type 5% it still goes to
0.00%

can anyone advise what i am doing wrong?

thanks.

 

[Rick Brandt]

hi all,

this is probably a very stupid question to you guys but it is driving me
nuts:-

i am trying to create a field that allows me to enter a number as a
percentage. in table design, i set the data type to number and then set the
format to percent.

however, when i then go in the table and enter, for example, 5 it change to
500%. if i type 0.05 or 0.5 it goes to 0%. if i type 5% it still goes to
0.00%

can anyone advise what i am doing wrong?

thanks.

What size of number? It needs to be a size that supports fractional
values. Integer and Long Integer do not.

IMO it is a very stupid interface design to have one "type" called
number and use the "size" setting to distinguish between the sub-types.
I don't know of any other database that does this besides Access.

 

[borris]

What size of number? It needs to be a size that supports fractional
values. Integer and Long Integer do not.

hi, thanks for rewplying.

when you mean size of number do you mean the percentage range? if so, it'll
be between 0% and 100%.

is this what you meant?

 

[Rick Brandt]

hi, thanks for rewplying.

when you mean size of number do you mean the percentage range? if so, it'll
be between 0% and 100%.

is this what you meant?

No. In table design view you give each field a DataType (like Number).
When "Number" is used you then have an additional property for the
Field Size. For a Number the choices are...

Byte
Integer
Long Integer
Single
Double
Currency
Replication ID

The first three do NOT allow for fractional values and will truncate or
round all entries to a whole number.