Exporting to text file

  • Thread starter Thread starter JoAnna
  • Start date Start date
J

JoAnna

I'm exporting to a text file, I have the specs set based on col width. I
have a col that I want to round up. When I view the text file the number has
been rounded up but the decimal is still there with 00's
 
Create a query that formats the number the way you want it, and export that
query.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which illustrates how to do this.
You can download it for free here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=351

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top