decimal places in Access

  • Thread starter Thread starter Joe V
  • Start date Start date
J

Joe V

I have a column in a table where I show a number. I
enter data with decimals, but the table display on
screen, and any reports I make from it show no data after
the decimal place. The field is configured as "number"
and the "decimal place" property is set to 4. But no
decimal data (or even the decimal point itself) ever
shows. How do I get it to display and print the 4
decimal places??
 
What's the data type of the number? (The "Field Size" property, two up from
the "Decimal Places"). The default number type is Long Integer. Unless
you've changed it to Single or Double, you won't get any decimal points.
 
Data type was "decimal". I just changed it to "long
intiger", and saved the change. I tried a data entry and
it still did not show the 4 decimal places I call for.
By the way, the Data Type is "number".
 
I just re-read your note, changed "long integer"
to "double", and it worked! Thank you very much!
 
Back
Top