Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access2000 Table; Number Format

    I created a field in a table; Long Integer size, General Number format, 2 decimal places. However, when I enter a decimal number in the field in the table, it rounds up or down. (.5 becomes 0, 1.5 becomes 2). I really only want it to show one decimal place, though 2 would be fine.

    Help.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access2000 Table; Number Format

    Integer stores no fractions. Change your field to Single or Double Precision.

Posting Permissions

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