Export query data to text file...need to eliminate decimals! 1

[CodeMonkey76]

I'm hoping someone out here has done this successfully...

I need to export data from a query into a text file. The file only needs to contain three fields:

AcctNumber
Amount
Notes

Now here's the tricky part...I need to remove the decimal point from the Amount and the quotation marks from around the account number.
For example:
34.55 should be exported as 3455

AcctNumber appears "99999" in the txt file when it should be, 99999.

Is there a function I can use to eliminate the decimal? Or is there some kind of way to use the Format field? I couldn't imagine Access not being able to do this...but then again...

Please help,
codemonkey in Cincinnasty

 

[JonFer]

Set up an Export Spec with the parameter "Text Delimiter = Nothing." For the numbers, you can multiply by 100 and use the Format(NumField,"0") function to drop any further decimal part.

Export the query manually first and press the "Advanced" button to set your options. Save the setup and use that in your macro or VBA logic.

 

[CodeMonkey76]

Thanks for the tip! Saved me some hours of painful searching and testing.