% and numbers

  • Thread starter Thread starter JB
  • Start date Start date
J

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
 
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.
 
wow that was quick.
That did it. Thank you !
Jen

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top