1. Dear Guest, we truly appreciate your patience while we are working hard on the upgrade process, which was forced upon us due to the decline of our original forum software. Good news is SPN is almost ready to resume its normal operations soon. The new cutting edge software has been chosen with a primary focus on enhancing user experience especially while using SPN on the mobile devices such as tablets or phones. This new platform will also provide us the opportunity to implement new ideas which were not possible in old software. Forum appearance will be an on going process and you would notice significant changes as we mature working in the new software environment. Some of the core functionality like the blogs will be restored gradually. Once, the forum is fully active, please take your time navigating around the new forum functionality. We will also introduce you to new functionality from time to time.

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?
     

Share This Page