export text file error

  • Thread starter Thread starter Slice
  • Start date Start date
S

Slice

I have built a query which includes formatting the amount field to return the
amount as a string. I use the export wizard on the query file and the wizard
displays the amount field as expected (leading zeros, no decimal). When I
complete the export and look at the export file, the file contains the amount
formatted as currency, but I need the field to be as a string. Need help
ASAP.
 
use the Format function instead of the format property of
the query column

field --> strNumber: Format([fieldname],"000")

substitute
"000" for your format code

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
 
Sorry for not responding sooner, but thanks for the reply. I had already
tried that and it made no difference. I noticed that from the original file
that was imported/converted was a currency field, which somehow affected the
way the export wizard worked. I eventually was able to work around the
problem. Thanks again.

Slice
use the Format function instead of the format property of
the query column

field --> strNumber: Format([fieldname],"000")

substitute
"000" for your format code

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
I have built a query which includes formatting the amount field to return the
amount as a string. I use the export wizard on the query file and the wizard
displays the amount field as expected (leading zeros, no decimal). When I
complete the export and look at the export file, the file contains the amount
formatted as currency, but I need the field to be as a string. Need help
ASAP.
Click to expand...
Click to expand...
 
you're welcome ;) happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com

Sorry for not responding sooner, but thanks for the reply. I had already
tried that and it made no difference. I noticed that from the original file
that was imported/converted was a currency field, which somehow affected the
way the export wizard worked. I eventually was able to work around the
problem. Thanks again.

Slice
use the Format function instead of the format property of
the query column

field --> strNumber: Format([fieldname],"000")

substitute
"000" for your format code

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com

I have built a query which includes formatting the amount field to return the
amount as a string. I use the export wizard on the query file and the wizard
displays the amount field as expected (leading zeros, no decimal). When I
complete the export and look at the export file, the file contains the amount
formatted as currency, but I need the field to be as a string. Need help
ASAP.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Table Data To Formatted Text File 2
Simple Methods to Export Gmail to Text? 1
Formatting output text as currency 3
How do I keep leading zeros and remove the decimal point when expo 2
TransferText acExportDelim unexpectedly truncates numeric field 4
How to Export a query to a new spreadsheet 4
Export Results of Access 2000 query to text file. 2
Loop through a record set to change a currency field based on average difference of two fields 0

Back
Top