export text file error

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

strive4peace

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
 
S

Slice via AccessMonster.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...
 
S

strive4peace

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