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

    HELP ..Calculation Error ?? (Access 2000 SR1)

    PLEASE HELP ...................I have a simple table with two fields both defined as Field Size = Double and Decimal Places = Auto for input of numeric values.

    When using an expression in a query to calculate the variance between these two fields I receive strange results on some, but not all records. A snapshot of the results are listed below. The expression is [FieldA]-[FieldB] .... has anyone run accross this before?

    Field A - Field B = Result
    123345.87 - 123345.87 = 1.45519152283669E-11
    1677.72 - 1677.72 = 2.27373675443232E-13
    737.99 - 737.99 = 0

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP ..Calculation Error ?? (Access 2000 SR1)

    Are the values in fieldA and fieldB result of calculation or are they keyed in ?
    Try to set the format to General number to see what's really in the field.
    You may have to round your values.
    ROUND(number,num_digits)
    Francois

Posting Permissions

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