MS Access table not taking decimal values

Posted on 2009-02-13
Last Modified: 2012-05-06
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?
Question by:servent1
    LVL 75

    Accepted Solution

    Set the Scale to at least 2

    LVL 18

    Expert Comment

    Set format to fixed or standard.


    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    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.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Just an FYI on Scale.

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


    Author Closing Comment

    Bingo!  Thanks much appreciated!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now