% and numbers

[JB]

I've got a column in a table that I want to make a percent value.
I enter 12.5 and it returns 12.000.00 !!!!!!!!!!!!!!
so it's calculating it for me I get it. I just want the figure.
So I make it a NUMBER, with 2 decimal places.
I enter 12.5 and it returns 12 !!??
I change it to auto decimal places
It returns 12
I change it to 1 decimal places., it returns 12.
Please, what am I missing here?
Jen

 

[Douglas J. Steele]

When you set a field in a table as Number, the default data type is Long
Integer, which cannot store any fractional part.

Take a look at the "Field Size" property in the bottom left of the design
interface. To store fractional parts, you need to use one of Single, Double
or Decimal.

 

[JB]

wow that was quick.
That did it. Thank you !
Jen

When you set a field in a table as Number, the default data type is Long
Integer, which cannot store any fractional part.

Take a look at the "Field Size" property in the bottom left of the design
interface. To store fractional parts, you need to use one of Single,
Double or Decimal.