How do I export a query without a currency symbol to a comma deli

P

Poppy

Good Day

I am trying to export a query that has fields formatted as currency into a
comma delimited file. I want the currency fields to be exported as a general
number.

I opened the query in design view and changed the currency fields to general
number under the propeties of the fields, however when I go ahead and export
the query, the fields still contain the currency symbols.

I then tried exporting the query using a macro to a txt file, but I'm not
given the option to save the file as comma delimited. The fields are
seperated by |.

Is there something that I'm missing?

Thanks for all your help

Kind Regards.
 
J

Joan Wild

Instead of changing the properties for the column in the query, change the
column to
Format([SomeField],"Fixed")

If Fixed isn't the format you want, check in Help for the other format
possibilities.
 
P

Poppy

Hi Joan

Thank you very much for your help. It's taken out the currency symbols.

Kind Regards

Joan Wild said:
Instead of changing the properties for the column in the query, change the
column to
Format([SomeField],"Fixed")

If Fixed isn't the format you want, check in Help for the other format
possibilities.


--
Joan Wild
Microsoft Access MVP
Good Day

I am trying to export a query that has fields formatted as currency
into a comma delimited file. I want the currency fields to be
exported as a general number.

I opened the query in design view and changed the currency fields to
general number under the propeties of the fields, however when I go
ahead and export the query, the fields still contain the currency
symbols.

I then tried exporting the query using a macro to a txt file, but I'm
not given the option to save the file as comma delimited. The fields
are seperated by |.

Is there something that I'm missing?

Thanks for all your help

Kind Regards.
Click to expand...
Click to expand...
 
Top