Export Delimited txt File

[GAVO-UK]

Using Ms Access 2003

I am trying to export a query to a delimited txt file containing some
CURRENCY fields, which I want to export without the currently symbol
and with five decimals. I have tried everything to get the currency
fields with the format I want after exporting but!! NO LUCK!!!

This is what I have tried.

In the source table the fields are formatted with a DataType=
"Currency" and the Format = "Standard"

In the query the fields source are currently something like this

TADolars: Format$([TODueDolars],"#,##0.00000")

I have also tried changing the DataType on the source table to Number
and Format=Currency but no Luck either

The funny thing is that when I preview the query the fields format are
just exactly what I want, but when I export (using a saved
import/export specification) the currency fields go back to £0.00000
(The decimals Work!!!!)

So the question is HOW DO I EXPORT WITHOUT THE CURRENCY
SYMBOL??????????

Thanks

[John Sheppard]

Hello there,

Perhaps you could try making a query using that formula in the select fields
and then exporting the query.
Might not make any differents, just an idea

Thank you
John
"GAVO-UK" <an****@peopleex.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Using Ms Access 2003

I am trying to export a query to a delimited txt file containing some
CURRENCY fields, which I want to export without the currently symbol
and with five decimals. I have tried everything to get the currency
fields with the format I want after exporting but!! NO LUCK!!!

This is what I have tried.

In the source table the fields are formatted with a DataType=
"Currency" and the Format = "Standard"

In the query the fields source are currently something like this

TADolars: Format$([TODueDolars],"#,##0.00000")

I have also tried changing the DataType on the source table to Number
and Format=Currency but no Luck either

The funny thing is that when I preview the query the fields format are
just exactly what I want, but when I export (using a saved
import/export specification) the currency fields go back to £0.00000
(The decimals Work!!!!)

So the question is HOW DO I EXPORT WITHOUT THE CURRENCY
SYMBOL??????????

Thanks

[GAVO-UK]

Thank Your John, but that is exactly what i have done and still not
luck....