Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated Field (Access 2000)

    Greetings all:

    I have a report that is sorted by a calculated field that contains Total Hours Worked (major key) and an In Class Date field (Minor Key). On the report, the total hours worked field shows 0.0 and the dates for this figure are not sorted properly. Upon further inspection of the query results that the report is based on, one of the Total Hours Worked field actually shows 1.13686837721616E-13. In fact, all the supposedly 0.0 fields show this kind of scientific notation. The calculated field is formated to standard number with one decimal place. What am I missing? As always, all assistance is greatly appreciated. TIA.

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

    Re: Calculated Field (Access 2000)

    You probably calculate hours worked by adding some figures together, then subtracting something else. Small rounding errors can occur when you do this, because the numbers involved cannot be stored with infinite precision. You could use a formula like this to round the results to 1 decimal place:

    Int(10 * [Hours]) / 10

    where Hours is the value you want to round.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Field (Access 2000)

    Thanks Hans,

    I'll have to wait until Monday to try this but it looks good. I'll let you and the forum know the results

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Field (Access 2000)

    Thanks again Hans,

    Works perfectly.

Posting Permissions

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