Access: How can I export currency value without the $

[nesster13]

I have a query that extract the value I want from the master table but
one of it field is in currency format. It does not show the $ when I
run the query but when I try to export it into a text file, the 4
showed up. Is there anyway to export without the $?

Any help is greatly appricated.

 

[Van T. Dinh]

Try using a Calculated Field instead of the currency Field in your Query
like:

ExportField: Format([CurrencyField], "0.00")

(or whatever the format you want to use.)

 

[nesster13]

Thank you very much Van. It was a great help.