Access Export - Possible Rounding Problem

Discussion in 'Information Technology' started by Chet Shaner, Jul 28, 2006.


  1. Chet Shaner

    Chet Shaner Guest

    Have an Access db that we are exporting data to a CSV formatted file. Have
    some fields in tables defined as Double data type (General Number, auto
    decimal). When exporting the data, getting strange rounding of the numbers,
    some up and some down. If I change the defined data type to Single (General
    Number, auto decimal) the exported data appears to be correct and correctly
    formatted.

    We are manipulating the data before export by queries and code. The only
    mathematical operations are addition and subtraction.

    Any Ideas?
     
Loading...

Share This Page