Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Decimal places not appearing (97)

    I specified a number field size as a byte with 3 decimal places. When I type 6.574 the table rounds immediately to 7, what

  2. #2
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Decimal places not appearing (97)

    See:
    <A target="_blank" HREF=http://www.access-programmers.co.uk/ubb/Forum2/HTML/000902.html>http://www.access-programmers.co.uk/ubb/Fo...TML/000902.html</A>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Decimal places not appearing (97)

    Just to keep answers all in one place, the simple answer is that byte field size allows integers from 0-255. That's why you got rounding.

    To store any decimal places you need to use Single, Double, or Currency depending on your needs.

    See the built-in help for more details.

Posting Permissions

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