Decimals in Table

  • Thread starter Thread starter Marquis
  • Start date Start date
M

Marquis

I can not get my table to accept decimals, i.e. .85
or .97. It changes the data to 1 instantly. I was
originally using percent in my tables, queries and forms.
The queries/forms contain formulas that result in a
percent value. When I initially tried to enter data as 85%
it would convert it to 8500% and I could not get it to be
just 85%. I've tried percent, general and fixed formats
for this data with all the accepted decimal places. I
finally rested on just using 1 as 100% b/c the
calculations would handle that but I'm not sure how I
would get 85% to convert from an acceptable format. Am I
missing a rounding adjustment somewhere? This really feels
like a stupid question...but I'm at my end.
 
-----Original Message-----
I can not get my table to accept decimals, i.e. .85
or .97. It changes the data to 1 instantly. I was
originally using percent in my tables, queries and forms.
The queries/forms contain formulas that result in a
percent value. When I initially tried to enter data as 85%
it would convert it to 8500% and I could not get it to be
just 85%. I've tried percent, general and fixed formats
for this data with all the accepted decimal places. I
finally rested on just using 1 as 100% b/c the
calculations would handle that but I'm not sure how I
would get 85% to convert from an acceptable format. Am I
missing a rounding adjustment somewhere? This really feels
like a stupid question...but I'm at my end.
.
Is you number type set to double
Click to expand...
 
I can not get my table to accept decimals, i.e. .85
or .97. It changes the data to 1 instantly.
Click to expand...

It sounds like you used the default Number datatype, which is Long
Integer. An integer, by definition, has no decimal places.

Open the table in design view and select this field. At the bottom of
the screen you'll see the properties of the field; change the Long
Integer to either Float or Double and you'll be able to store
fractional values.
 
Back
Top