Values Changing on Import or Update

[Jim Medill]

Can anyone help -
I am importing an Ascii text file with decimal numbers ie (144392.26). the receiving field is defined as double with decimals set to auto. I have tried many other formats such as fixed 2 decimals, or Currency 2 decimals. In all cases the data has changed from its original value to 144392.265625 which of course rounds to 144392.27 on all reports. If I use a link to the same Ascii file the data retains its original value when it is appended to an empty table. But ... When I try to use that correct value in the appended table to update another table it again converts the amount to multiple decimals and may increase by more than .01.

Is there away around this problem.

Jim M

 

[Birdy]

Try using single. I had a similar problem for adding up values and there was a discrepancy of either .01 or .02. I changed the table field properties to single and this resolved the issue.