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

[Guest]

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.

 

[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.

 

[Guest]

Hi Joan

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

Kind Regards

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.