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,Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13531-access-export-possible-rounding-problem.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13531
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
We are manipulating the data before export by queries and code. The only
mathematical operations are addition and subtraction.