Exporting number fields and retaining the decimal point position

[Max]

hi,

easier to give an example:-
I have a field described as a double with 4 decimal places
eg 0.005
when i export it to a csv file it becomes:-
5.0e-03
fair enough, but what i really want is 0.005. I don't want to change the
field to text. I want retain it as a number (of any sort)
If Access won't do it, is there another tool i could use?

help

Max

 

[Fernando]

Create a query and give format to your field

mifield=format(field,"0.0########").

Then export the query to CSV.

I got this trick from this group of news.

Regards

 

[Max]

thanx Fernando,

looks a good idea

salud

John

Create a query and give format to your field


Then export the query to CSV.

I got this trick from this group of news.

Regards