• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 976
  • Last Modified:

MS Access table not taking decimal values

I want to have a decimal value in my table so I have a field type
of number and with the field size as decimal.  But  in data view when I enter
in a decimal like .62 it puts in a zero.

What do am doing wrong?
0
servent1
Asked:
servent1
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Set the Scale to at least 2

mx
0
 
jmoss111Commented:
Set format to fixed or standard.

Regards,

Jim
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You will still need the Scale property set to at least 2, otherwise .. even with Format - which is not really necessary .. if you enter 0.62 ... you will get 0.00 - if Scale is at zero.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Just an FYI on Scale.

Scale is the Maximum number of digits that can be stored to the right of the decimal separator.

mx
0
 
servent1Author Commented:
Bingo!  Thanks much appreciated!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now