Problem when exporting

[Jokkis]

I'm exporting data from a query to a csv-file, and experience a problem with one of the fields. The field is a DOUBLE with FIXED FORMAT and TWO decimal places. The query returns a number of rows, but the problem only occurs for one of the rows:

When I look at the field in the query it shows 0.00 (which is what I want it to show when exported), but when I export the results to a csv-file it shows
-1.13686837721616E-13 (which is very close to 0.00, but not in the correct format...). The field is created through a number of calculation steps (adding and subtracting numbers), so it's probably due to calculations in Access that the number appears as close to 0 rather than exactly 0. However, I've forced Access to show the result in FIXED format with TWO decimal places (also in field properties in query design view).

Why does 0.00 appear as -1.13686837721616E-13 when exported to a csv-file?

Many thanks for your help on this.

Jokkis

 

[PHV]

Have you tried to use a conversion function like CCur ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Jokkis]

Hi PHV

Big thanks for your input.

No, I haven't tried that function. But how do you apply such a function for a specific field in a query result during an export procedure?

 

[Golom]

Export from a query using something like

Select cCur([SomeField]) As [SomeCurrencyField], ...