C
Chuck
Hi,
I am using a query and TransferSpreadsheet to export a table to Excel.
The table column is defined as double with 2 decmial places.
The data is accouting transactions. In the same column there is a negative
number followed by many rows of positive numbers that sum to 0. This series
repeats for about 20 transactions.
The transfer to Excel works fine.
Then in Excel, for only about 3 of the 20 transactions , when I select the
positive amounts they total to the negative amount, but when I select both
the positive and negative amounts the sum= at the bottom of the page I get
something like sum=-2.15458E-13. All the rest of the transactions I get sum=0.
If I just select the positive and negative amounts and use the tool bar
button to increase then decrease the decmial places, then it totals to 0.
It is one query that is being executed once. Any ideas why it only affects a
few transactions? Any ideas on how to fix it?
Thanks
I am using a query and TransferSpreadsheet to export a table to Excel.
The table column is defined as double with 2 decmial places.
The data is accouting transactions. In the same column there is a negative
number followed by many rows of positive numbers that sum to 0. This series
repeats for about 20 transactions.
The transfer to Excel works fine.
Then in Excel, for only about 3 of the 20 transactions , when I select the
positive amounts they total to the negative amount, but when I select both
the positive and negative amounts the sum= at the bottom of the page I get
something like sum=-2.15458E-13. All the rest of the transactions I get sum=0.
If I just select the positive and negative amounts and use the tool bar
button to increase then decrease the decmial places, then it totals to 0.
It is one query that is being executed once. Any ideas why it only affects a
few transactions? Any ideas on how to fix it?
Thanks