Transfer Text function

[tlaksh]

I am using the following command to export data

DoCmd.TransferText acExportDelim, "HourSpec", "HoursData",
filename, True

When I run the query HoursData the following result is displayed on screen

Actual DOLLARS.INPUT 1000111TA 61056 01420000 d 20040011 15.50

but the actual text file looks like this

Actual,DOLLARS.INPUT,1000111TA,61056.00,01420000,s,20040011.00,22.50

Can anyone please let me know how I can get rid of the decimal places in 61056.00 and 20040011.00.

Thank you
Lakshmi.

 

[SarahG]

You could try converting these fields to a string before output so the system won't see them as a number and add on decimal places. See the CStr() function.

 

[PHV]

You may also consider playing with the Format function in your query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244