A field for probability number – 0.5

[Mike P]

Hello,

I have a table with a number field named Probability. The data in the field is going to be a number between 0 and 1. Most likely something like .4 or .05 and such. I cannot seem to enter numbers into the table that start with a point, such as a .3 or 0.3 I have the field type set to number, the Field Size as Integer, the Format as General Number, and the Decimals set to 3.

Thanks in advance for you help in this, I am totally stuck!

Mike

 

[Brian Camire]

"Field Size as Integer" means the number must be an integer -- that is a
signed *whole* number.

Try using a Field Size of Double (or Single, or Decimal with a Scale of
greater than zero) instead.

Hello,

I have a table with a number field named Probability. The data in the

field is going to be a number between 0 and 1. Most likely something like
..4 or .05 and such. I cannot seem to enter numbers into the table that
start with a point, such as a .3 or 0.3 I have the field type set to
number, the Field Size as Integer, the Format as General Number, and the
Decimals set to 3.

 

[John Vinson]

Hello,

I have a table with a number field named Probability. The data in the field is going to be a number between 0 and 1. Most likely something like .4 or .05 and such. I cannot seem to enter numbers into the table that start with a point, such as a .3 or 0.3 I have the field type set to number, the Field Size as Integer, the Format as General Number, and the Decimals set to 3.

Check the dictionary definition of the word "Integer" - it's a whole
number with no fractional part!

Change the Field Size to Single (which will give you approximately
seven decimals precision) or Double (14 decimals), and allow an
enormous range of values. You may also want to set a validation rule
such as

= 0 AND <= 1.0

to prevent unreal probabilities such as -0.7 or +3.2144x10^295.