Exporting query to text file results in added decimal places on INT fields???

[pointBoarder]

I'm using the following to dump a simple query to a text file.

qryRecalcOutput:
SELECT reorder_recalc.[Part Number], Int([Revised Re-Order Point]),
Int([Revised Re-Order Qty]) FROM reorder_recalc;

Statement:
DoCmd.TransferText acExportDelim, "", "qryRecalcOutput", "output.txt",
True

Problem:
The output.txt file is appending .00 to every row value in columns
"Revised Re-Order Point" and "Revised Re-Order Qty". If I export the
file to excel format or view the query in detail view I see only the
Int values as I would expect.

Any thoughts?

Thanks in advance,
Derek

[pointBoarder]

Format$(Int([Revised Re-Order Point]), "0") seems to do the trick

looks like access03 wins again