Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    Colusa, CA
    Posts
    13

    Unhappy Unanswered: I need help with a number field!

    I have a table that I use that keeps track of time on a job. However, it will only keep whole hours. So I was wondering how I can change it to keep 1/2 and 1/4 hours.

    When I type in 8.5 and tab over top the next field it just says 8.00
    When I type in 8.75 it goes to 9.00

    I am thinking it is a rounding error but I am not sure where to even begin!

    Thanks
    Chris

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    See it this helps....

    Make sure the Field Size property (in table) for all the fields that will be holding hours of some kind, is set to Single.


  3. #3
    Join Date
    Apr 2004
    Location
    Colusa, CA
    Posts
    13
    This did not help. I think it is a rounding issue but I am not sure how to check that!

  4. #4
    Join Date
    May 2004
    Posts
    14
    When I type in 8.5 and tab over top the next field it just says 8.00
    When I type in 8.75 it goes to 9.00

    I am thinking it is a rounding error but I am not sure where to even begin!
    it can't be a rounding problem if you get 8.0 from 8.5.

    Give us the field properties or post the table here so we can look at it. Are you adding numbers directly into the table or are you using a custom form for data entry? Does the form show the rounded number and the table show the exact number? If you are using a form, it might be that the form properties are set for the number format change.

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by chris86924
    This did not help. I think it is a rounding issue but I am not sure how to check that!
    Try checking out your Decimal placing. That happened to me once.

    Bud

Posting Permissions

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