Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    numbers round (2003)

    I have a db with a field set as a general number. I am trying to enter 2.05, but it displays 2. I have tried using fixed digit set to 2, but that doesn't work either. What am I doing wrong? I need this number field to show the number as it is entered.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: numbers round (2003)

    If the size of the field is Byte, Integer or Long Integer, it will only store whole numbers.
    If you want to be able to store fields with a fractional part, set the field size to Single or Double. Or use a Currency field instead of a Number field.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: numbers round (2003)

    It sound like the field is set to be an Integer or Long Integer. Integers are whole numbers.
    In the Design of the table, change it to a single or double, which refers to single or double precision decimals.
    Regards
    John



  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: numbers round (2003)

    Bingo. Jeesh. Thank you!! I read the help screen in Access, but I guess I misinterpreted what it said. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •