Results 1 to 2 of 2

Thread: Sum problem

  1. #1
    Join Date
    Jul 2004
    Posts
    10

    Unanswered: Sum problem

    I have having a problem with the sum function of fields. The field I wish to sum contain the following values:

    2.9404404404404454E-4
    2.9404404404404454E-4
    4.7999999999999998
    4.7999999999999998
    4.7999999999999998
    4.7999999999999998

    instead of getting a value of 19.20 with the sum function I'm getting a sum of: 25.08

    To me the sum function doesn't recognise 2.9404404404404454E-4 as .0000294044????

    Is there a way to fix this?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    It says 19.200588088088089 to me. What does the statement look like? What's the ddl of the table you select from?

Posting Permissions

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