$ Showing in TXT file but not in query

[tcheck]

I am exporting a query to a TXT file that is pipe delimited. I have about 15 fields in the query and all numbers must be fixed with no commas or dollar signs. When I run the query everything looks fine, but when I export the query to a text file, I have 2 fields that contain $ an ,'s. The fields are calculated like this;



IIf([net_money]<0,[net_money]*-1,[net_money])

When I view the file there are no dollar signs or commas, When I put them into a TXT file I get the fields with the formatting which I do not want. I am exporting the file using this command;

DoCmd.TransferText acExportDelim, "Export_XXXX File", "qry_jXXXX", "J:\operations\PRD\Janus\" & Format(Date, "YYYYMMDD") & ".txt", True

Export_XXXX is the Specification file.

Any ideas?

[JoeM]

In you query, have you exlicitly formatted each of those fields (select the field in the Query Builder, right click, and select Format)?
Explicitly choose the format you would like.
Now, try exporting the query manually and see if it turns out OK.
If it does, try running it from your command and see if that works.
If it works properly when exported manually, but not when done by your command, I think you need to rebuild your Export Specification.

[tcheck]

Thanks. I did format the fields to Fixed. I will try and rebuild the spec file.

[tcheck]

Went through the Import section in Access and found the Specification and edited it. The specification called for both of the 2 above fields to be currency. Changed it and not it works. Thanks.

[JoeM]

Changed it and not it works.

I assume you meant "now it works", but if I assumed wrong, and the issue still isn't resolved, let us know.