Access Export - Possible Rounding Problem

C

Chet Shaner

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding difference in Access 2003 text exports 2
Rounding Numbers 2
Stop Rounding in Forms 2
Adding data to MS Access from csv file 0
Internal Data Integrity (Type 4) Details Needed 1
Number rounding issue 2
ACCESS TO EXCEL 1
Preventing rounding numbers to nearest dollar 1

Top